| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a table based on rank
Hi, I have a list of 13 names in one column and in the adjacent column a score for each one. Based on this score I have ranked them 1-13 in another column. On a different worksheet I have a column with 1-13 listed in decending order. I would like to populate the column adjacent to this with the name that corresponds to the same rank on the other spreadsheet. A small example as follows: Spreadsheet 1: Rank Name Score 2 Apple 13 4 Orange 2 1 Grape 15 3 Pear 10 Spreadsheet 2 (should look like this):- Rank Name 1 Grape 2 Apple 3 Pear 4 Orange Many thanks in advance if any of you can help. Regards, GW -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=499531 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a table based on rank
A vlookup should work.
=vlookup(a1, sheet1!a1:b13, 2, false) "giantwolf" wrote: Hi, I have a list of 13 names in one column and in the adjacent column a score for each one. Based on this score I have ranked them 1-13 in another column. On a different worksheet I have a column with 1-13 listed in decending order. I would like to populate the column adjacent to this with the name that corresponds to the same rank on the other spreadsheet. A small example as follows: Spreadsheet 1: Rank Name Score 2 Apple 13 4 Orange 2 1 Grape 15 3 Pear 10 Spreadsheet 2 (should look like this):- Rank Name 1 Grape 2 Apple 3 Pear 4 Orange Many thanks in advance if any of you can help. Regards, GW -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=499531 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating a table based on rank
You're absolutely right. Thanks. GW -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=499531 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I create a pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
| creating a pivot table w/ ranges from 2 worksheets | Excel Discussion (Misc queries) | |||
| I am having problems creating pivot table of data | Charts and Charting in Excel | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
| pivot table - Rank | Excel Discussion (Misc queries) | |||
Linear Mode
