| 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) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pick last date in a column if more than two similar dates
If you always want the last thing in that column and there are no gaps in the
range, you could use a formula like: =index(a:a,counta(a:a)) MSSailor wrote: 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) -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pick last date in a column if more than two similar dates
=LOOKUP(2,1/(B1:B20=A1),C1:C20)
-- Best Regards, FARAZ A. QURESHI "MSSailor" wrote: 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) |
| Reply |
| 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 | |||
Hybrid Mode
