Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup without repeats
Hi!
Below is a table of data that I have: Name1 5 Name2 10 Name3 15 Name4 20 Name5 5 Name6 5 Name7 25 Name8 30 Name9 40 Name10 50 I am then resorting the second column in descending order and then matching (using INDEX and MATCH) the name to the number. My problem arises where I have the same number (Name1, Name5, and Name6 all have a value of 5). I think I need to use OFFSET here, but I'm not sure exactly how. Thanks in advance! Brett |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste VBA repeats and repeats | Excel Discussion (Misc queries) | |||
lookup values vertically in a list and return the repeats | Excel Worksheet Functions | |||
NO REPEATS | Charts and Charting in Excel | |||
No repeats of name in same colum | Excel Discussion (Misc queries) | |||
Count repeats | Excel Worksheet Functions |