Rank data by names

[sjak]

EDIT: I have attached the two tables in an excel document

From this table:

Column A Column B
Row 1 "Name One" 5
Row 2 "Name Two" 1
Row 3 "Name Three" 3
Row 4 "Name Four" 7
Row 5 "Name Five" 2

How can I rank the top three names too look like this:

Column A Column B
Row 1 "Name Four" 7
Row 2 "Name One" 5
Row 3 "Name Three" 3

I am already using the LARGE function to calculate the highest, second highest etc. numbers, my only trouble is having the accompanied name beside it in another cell.

Any help would be great,

sjak

[NBVC]

If there is no chance of repeating the Column B number (ie. Two 7's), then try this formula in B9:

Please Login or Register  to view this content.

If there can be repeated column B numbers, then try:

Please Login or Register  to view this content.

The formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER.. you will see {} brackets appear around it.

then copy down either formula.

[sjak]

Perfect, thanks again NBVC.

Solved.

sjak

[ChemistB]

Just curious why you wouldn't highlight the range and sort by column B?

ChemistB