Just hazarding some guesses here ..
(I agree with Mark that you should be more specific)
Assuming the data posted is in cols A to E from row1 down,
where col D is the key col = numbers: 25,25,8,3,4 etc
Put in say, G1:
=INDEX(A:A,MATCH(MAX($D:$D),$D:$D,0))
Copy G1 to K1 to return the source line with the max number in col D
Format K1 as date
Should there be any tied maximum numbers in col D, then only the 1st line
(ie the higher up one) gets returned into G1:K1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jlindner" wrote:
> I want to get the max # from a worksheet with multiple rows of my key value.
>
> WM-DV028 Windows WDW 25 3/29/2006
> WM-DV028 Windows WDW 25 3/30/2006
> WM-DV028 Windows WDW 8 3/31/2006
> WM-DV028 Windows WDW 3 4/3/2006
> WM-DV028 Windows WDW 4 4/4/2006
> WM-DV028 Windows WDW 7 4/5/2006
> WM-DV028 Windows WDW 24 4/6/2006
> WM-DV028 Windows WDW 32 4/7/2006
> WM-DV028 Windows WDW 8 4/8/2006
>
> this worksheet has >40 lines this is just a sample.
> Is there a way to combine vlookup with max?
>
>
> --
> jlindner
Similar Threads
