Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ranking in order
Good afternoon,
I am trying to rank and place in order my findings. Example: A B 1 2 Y 2 1 N 3 0 N/A I have been able to get column C to display the highest number, but my problem now is how do I get the name that ranks highest to be displayed. in the above example it would be "Y" because it ranks highest. thank you for your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ranking in order
You can use VLOOKUP to retrieve the name. In this case, if the highest
number is in C1, you can use: =VLOOKUP(C1,A1:B3,2,FALSE) The drawback of this function is that if you have more than one row with the same value in the column A, it will only return the first appearance. Hope this helps, Miguel. "tryn''''2learn" wrote: Good afternoon, I am trying to rank and place in order my findings. Example: A B 1 2 Y 2 1 N 3 0 N/A I have been able to get column C to display the highest number, but my problem now is how do I get the name that ranks highest to be displayed. in the above example it would be "Y" because it ranks highest. thank you for your help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ranking in order
that worked great!
Thank you for such a quick reply! "Miguel Zapico" wrote: You can use VLOOKUP to retrieve the name. In this case, if the highest number is in C1, you can use: =VLOOKUP(C1,A1:B3,2,FALSE) The drawback of this function is that if you have more than one row with the same value in the column A, it will only return the first appearance. Hope this helps, Miguel. "tryn''''2learn" wrote: Good afternoon, I am trying to rank and place in order my findings. Example: A B 1 2 Y 2 1 N 3 0 N/A I have been able to get column C to display the highest number, but my problem now is how do I get the name that ranks highest to be displayed. in the above example it would be "Y" because it ranks highest. thank you for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generate Auto Order Number | Excel Discussion (Misc queries) | |||
Series order conflicts with line order | Charts and Charting in Excel | |||
Print order of worksheets | Excel Discussion (Misc queries) | |||
Maintaining a default worksheet order | Excel Discussion (Misc queries) | |||
Order ranking. Any suggestions? | Excel Worksheet Functions |