| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How-to automatically select and chart the highest 10 totals? | Excel Discussion (Misc queries) | |||
| SELECT large amount of data in a worksheet | Excel Discussion (Misc queries) | |||
| Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
Hybrid Mode
