Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup function returns duplicate values
It's been a long time since I wrote any formulas, and it is showing.
I have a stat sheet for my basketball players, I am trying to pick the top 3 in a certain category. Everything goes great, until there are duplicate values that are associated with different player names. I need to have it not only sort the top three values, but return the exact three names that go with each value (which in some cases is the same value). Last FT % Harriss 66.67% Harriss Wiger 50.00% Wiger Shuck 50.00% Shuck Ostergard 66.67% Ostergard McCann 0.00% McCann Usselman 66.67% Usselman Bryant 0.00% Bryant Chamberlain 42.31% Chamberlain Fletcher 50.00% Fletcher Liebelt 60.00% Liebelt Hamilton 25.00% Hamilton Maney 33.33% Maney Voorhees 37.50% Voorhees Player 0.00% Player Player FT % Harriss 66.67% Harriss 66.67% Harriss 66.67% Formula for finding the FT% is: =LARGE(B2:B15,1) =LARGE(B2:B16,2) =LARGE(B2:B17,3) Formula for finding the Name associated with the FT% value is: =VLOOKUP(B19,B1:C15,2,0) =VLOOKUP(B20,B1:C16,2,0) =VLOOKUP(B21,B1:C17,2,0) Now I understand why it is returning the same value, because of the simple logic involved, however I am looking for a condition to write to add to this so that it picks the next name involved and appropriately returns it. I hope this made sense. -- Appreciate your time, Ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup for multiple duplicate numerical values | Excel Worksheet Functions | |||
VLOOKUP returns unwanted/wrong values | Excel Worksheet Functions | |||
Array function that returns values within several intervals | Excel Worksheet Functions | |||
How do I write a VLOOKUP function that returns 0's, not neg vals? | Excel Worksheet Functions | |||
VLOOKUP with duplicate returns | Excel Discussion (Misc queries) |