jevi
Active Member
- Joined
- Apr 13, 2010
- Messages
- 339
- Office Version
- 2016
- Platform
- Windows
Hi All,
I have different columns and 150.000 rows, in column F I have the client ID, while in column BH I have the amount. I would like to have a formula (not a pivot table as I did it with Pivot) to sum only one amount but it should be included the amount per ID with the 10 nth largest amounts.
Example:
ID 10 it might be reapeated a lot of times in row F, so I need the sum of ID10 (all the amounts).
So i need the 10 largest amounts per ID just a sum of them all.
Thank you,
I have different columns and 150.000 rows, in column F I have the client ID, while in column BH I have the amount. I would like to have a formula (not a pivot table as I did it with Pivot) to sum only one amount but it should be included the amount per ID with the 10 nth largest amounts.
Example:
ID 10 it might be reapeated a lot of times in row F, so I need the sum of ID10 (all the amounts).
So i need the 10 largest amounts per ID just a sum of them all.
Thank you,