| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pick last date in a column if more than two similar dates
Have to lookup for the last day in a column A, The thing is that if I have
more than one similar date, it takes the first one in the column. Column A 2009-03-03 2009-03-04 2009-03-05 2009-03-06 Mentioned formula picks this value 2009-03-06 I WANT THIS ONE.......... How to add the formula to look after the last day and pick the last value? This what I have now! =VLOOKUP(MAX(A9:A36),A9:L36,COLUMN(A20),FALSE) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing dates in a date formated column ? | Excel Discussion (Misc queries) | |||
| sumproduct & Dates & similar Data | Excel Discussion (Misc queries) | |||
| Sumproduct & Dates & Similar Data | Excel Worksheet Functions | |||
| Count if date is between two dates and value in another column equ | Excel Worksheet Functions | |||
| line graph-need to pick up dates as values for the x axis? | Charts and Charting in Excel | |||
Threaded Mode
