Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Index/Match Help
Hi, I am trying to do an index match with duplicate values. I have 2 sheets "Sheet A" and "Sheet B". In "Sheet A" I have names of individuals and their scores. A B John 80.5% Tom 70.6% Mary 92.8% Jack 80.5% Harry 67.3% Lisa 55.5% Hazel 92.8% In "Sheet B" I am trying to rank the scores in Col A with the formula "=LARGE(Sheet A!$B$2:$B$8,ROW()-ROW($A$2)+1) and then I am trying to do an Index/Match so that I can get the corresponding names in Col B. But the porblem is that since there are duplicate values for the scores, it returns the same name twice. Is there a way around it? -- singsunnyboy7 ------------------------------------------------------------------------ singsunnyboy7's Profile: http://www.excelforum.com/member.php...o&userid=25623 View this thread: http://www.excelforum.com/showthread...hreadid=390375 |
#2
|
|||
|
|||
Check out http://www.cpearson.com/excel/rank.htm Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=390375 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
one more time index/match | Excel Discussion (Misc queries) | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Index/Match to look up a value in one workbook and insert it into. | Excel Discussion (Misc queries) | |||
Index/Match Help | Excel Worksheet Functions |