| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to relate last cell of info to another cell
I have created a spreadsheet that shows ppls attendance as the 'y' axis and
the date they attended as the 'x' axis. I want to create a formula that will tell me the last date they attended. Im guessing that it would have to start in the row for the person that I am looking at, search for the last cell with informaion and then cross reference to the date above.... I hope that makes since.... Help please!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move cell info and info in neighboring cell on new entry | Excel Discussion (Misc queries) | |||
| Combining multiple cells in column to relate to one cell in 1st co | Excel Discussion (Misc queries) | |||
| Formula for copying tap info into a cell | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| If Info In Cell Then Formula In Another | Excel Discussion (Misc queries) | |||
Threaded Mode
