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