|
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 |
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 |
| All times are GMT +1. The time now is 01:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com