ExcelBanter - select highest value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - select highest value (https://www.excelbanter.com/excel-worksheet-functions/106588-select-highest-value.html)

select highest value

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?

Naveen

select highest value

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.

"JK" wrote:

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?

All times are GMT +1. The time now is 12:50 AM.