Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I have a formula refer to the most recent entry in a row
I am using a spreadsheet to compile monthly results for my company. Some
results are YTD and I would like to have the most recent month show up for the YTD total. Is there a formula I can input that will look for the last entry in a particular row and populate that? |
#2
|
|||
|
|||
If you mean return the right most value in a row then try for row 4:
=LOOKUP(2,1/4:4,4:4) -- HTH Sandy Replace@mailinator with @tiscali.co.uk "sm7301" wrote in message ... I am using a spreadsheet to compile monthly results for my company. Some results are YTD and I would like to have the most recent month show up for the YTD total. Is there a formula I can input that will look for the last entry in a particular row and populate that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dragging a formula | Excel Discussion (Misc queries) | |||
How do I refer to the tab name in a cell formula in Excel? | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions |