On the same sheet for simplification, with your data in a2:b9, with
the numbers 1,2,3 in cells e2, e3, e4:

I got your top 3 scorers in column G with

=LARGE($B$2:$B$9,E2)

then in column F i picked up the corresponding names with

=OFFSET($A$1,MATCH(G2,$B$2:$B$9,FALSE),0)

The formula will be more complicated if you have to allow for ties.
If you copy the two formulas down 8 rows and fill in the sequence
1,2,...8 in column E you will see that Fred shows up for both zeros.

Good luck

Ken
Norfolk, Va

On Jul 17, 2:53*pm, Basenji wrote:
On sheet 1 in column A is the name of the account; same sheet column B is a
percentage.

Account * * Percentage
Mercy * 80.4%
Henry * 89.6%
Fred * *0.00%
Chris * 92.70%
Connie *92.00%
Alex * *92.60%
Larry * 89.80%
Ollie * 0.00%

On a second sheet (a summary sheet) a formula is needed to sort and rank the
accounts so that the account with the highest percentage is at the top of the
list, like this,

Chris * * * * 92.70%
Alex * * * * *92.60%
Connie * * * 92.00%
etc

I have tried a combination of formulas but have been unsuccessful.
Thank you.