select highest value

J

JK

I am working on an excel spreadsheet where I have a table of 120 customers
and their revenue in year 1 and year 2, is there a formula that I can write
to extract the top 5 customers(in terms of revenue) from the table?
 
N

Naveen

Try this, start from A1
A1

Customer Revenue Rank
ABC1 580 =RANK(B2,$B$2:$B$11)
ABC2 677 copy the above formula to remaining cells in
ABC3 593 this column, up to last row i.e., C11
ABC4 625
ABC5 244
ABC6 310
ABC7 771
ABC8 567
ABC9 561
ABC10 1054


Please Rate me.
 
Top