| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
vlookup and max ?
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
vlookup and max ?
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 What maximum value are you looking for? After you get that value, what are you looking to pull from the table? You need to be more specific. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
vlookup and max ?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
