Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Excel Formula Problem
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="svolin" data-source="post: 1444423" data-attributes="member: 160453"><p>I've got a simple problem that's driving me crazy. I need the function name(s) that will allow me to "attach" a number (in a separate cell) to a column letter to create a cell designation o use in a sum formula. It's driving me crazy because i did it about two years ago, and then my computer and Time Machine backup had a fit - no backup, no file.</p><p></p><p>Briefly, I have a spreadsheet of ten columns (one a date column), added to daily (almost 700 rows to date). The problem is to run different totals based on different dates, and, as a further complication, I have to keep a file of weekly totals. This worked fine using two "source" cells to define the row numbers and having a formula which attach the column letter to the row numbers in the cells.</p><p></p><p>It seemed so simple two years ago........ Help. Thanks</p></blockquote><p></p>
[QUOTE="svolin, post: 1444423, member: 160453"] I've got a simple problem that's driving me crazy. I need the function name(s) that will allow me to "attach" a number (in a separate cell) to a column letter to create a cell designation o use in a sum formula. It's driving me crazy because i did it about two years ago, and then my computer and Time Machine backup had a fit - no backup, no file. Briefly, I have a spreadsheet of ten columns (one a date column), added to daily (almost 700 rows to date). The problem is to run different totals based on different dates, and, as a further complication, I have to keep a file of weekly totals. This worked fine using two "source" cells to define the row numbers and having a formula which attach the column letter to the row numbers in the cells. It seemed so simple two years ago........ Help. Thanks [/QUOTE]
Verification
Post reply
Forums
General Discussions
Switcher Hangout (Windows to Mac)
Excel Formula Problem
Top