| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula needed: argument changes as more data is added
The math is simply the difference between the values in two cells, but one of
the cells will change each time the table is updated. For example, Row 1 headers are Apr, Mar, Feb, Jan, etc. and the last column is Prior Year. In At any given time, I want the value for the most recent month minus the prior year. How do I get it to automatically pick up the last non-blank cell in the row? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula or macro needed for sorting complex data issue. | Excel Discussion (Misc queries) | |||
| Deleting Rows With Non-Needed Data between Needed Data | Excel Worksheet Functions | |||
| Array in formula Vlookup changes when data list is added to | Excel Worksheet Functions | |||
| Masny argument Formula | Excel Discussion (Misc queries) | |||
| Need help with multiple argument formula | Excel Worksheet Functions | |||
Threaded Mode
