On sheet1, create a helper column (I'll assume column C), with this formula
entered in row 2 and copied down:
=RANK(B2,$B$2:$B$6)+IF(COUNTIF($C$1:C1,RANK(B2,$B$ 2:$B$6))0,1,0)

On sheet2, A2 formula is:
=INDEX(Sheet1!A$2:A$100,MATCH(ROW(Sheet1!$A1),Shee t1!$C$2:$C$100,0))

Copy down as needed, and across 1 column.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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.