Count the largest
I have a column of customers and an adjacent column of balances. I would
like to count the number of customers that account for 50% of the total amount of the balances. I am looking for a formula to do this for me. Any ideas? Thanks in advance. |
Count the largest
As you have names in an adjacent column I will assume the amounts are in column B, from Cell B1 downwards. In C1 put =LARGE(B:B,ROW()) In D1 put =IF(SUM(C$1:C1)<0.5*SUM(C:C),SUM(C$1:C1),"") and formula-drag those down as far as you have data. In E1 put =COUNT(D:D) This should be your count of those that total 50%. Note that the amounts in columns C to D do not represent the names on the same row, they are in order of greatest to least. Hope this helps Andrew Mackenzie Wrote: I have a column of customers and an adjacent column of balances. I would like to count the number of customers that account for 50% of the total amount of the balances. I am looking for a formula to do this for me. Any ideas? Thanks in advance. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=487907 |
All times are GMT +1. The time now is 12:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com