| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Top 10 values for each value in column X
I need to pull out the top 10 vales for each CompaNy in the following
example. It would be a combination of subtotal and filter top 10. Any ideas? Thanks so much for your help!! COMPANY $ ADAMS CORP. 8,035 ADAMS CORP. 5,663 ADAMS CORP. 1,431 ADAMS CORP. 1,117 ADAMS CORP. 1,016 ADAMS CORP. 973 ADAMS CORP. 900 ADAMS CORP. 842 ADAMS CORP. 761 ADAMS CORP. 699 ADAMS CORP 2134 AMERICAN COMPANY 12,344 AMERICAN COMPANY 2,229 AMERICAN COMPANY 1,842 AMERICAN COMPANY 1,492 AMERICAN COMPANY 1,305 AMERICAN COMPANY 1,266 AMERICAN COMPANY 1,223 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Top 10 values for each value in column X
Change ADAMS CORP. to the company you want the top 10 values for. Commit
this formula with CTRL+SHIFT+ENTER as it is an array formula. =LARGE(IF(A1:A20="ADAMS CORP.",B1:B20,""),{1,2,3,4,5,6,7,8,9,10}) -- Regards, Dave "Cecilia" wrote: I need to pull out the top 10 vales for each CompaNy in the following example. It would be a combination of subtotal and filter top 10. Any ideas? Thanks so much for your help!! COMPANY $ ADAMS CORP. 8,035 ADAMS CORP. 5,663 ADAMS CORP. 1,431 ADAMS CORP. 1,117 ADAMS CORP. 1,016 ADAMS CORP. 973 ADAMS CORP. 900 ADAMS CORP. 842 ADAMS CORP. 761 ADAMS CORP. 699 ADAMS CORP 2134 AMERICAN COMPANY 12,344 AMERICAN COMPANY 2,229 AMERICAN COMPANY 1,842 AMERICAN COMPANY 1,492 AMERICAN COMPANY 1,305 AMERICAN COMPANY 1,266 AMERICAN COMPANY 1,223 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| How sum values in column B using values in column A as the conditi | Excel Worksheet Functions | |||
Hybrid Mode
