| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working from oldest date
Hi there hope someone can help, here goes
Date RM MR 05/08/1997 £13.64 £53.41 04/05/1998 £62.94 £246.44 i am looking for a formula to check which date is the oldest and put in the corresponding amounts ie as above 05/08/97 is oldest date therefore A10= £13.64 A11= £53.41 and B10=£62.94 B11=£246.44 hope this makes sense!!!!!!!!!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Substracting from oldest date | Excel Discussion (Misc queries) | |||
| Finding the oldest date in a column | Excel Worksheet Functions | |||
| Find Oldest Date | Excel Discussion (Misc queries) | |||
| oldest date not completed | Excel Worksheet Functions | |||
| Detecting Oldest Date On Spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
