Count the largest - ExcelBanter

Posted to microsoft.public.excel.misc

Andrew Mackenzie

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Intervals of 1 Numeric value in a Row and Return Count down Column	Sam via OfficeKB.com	Excel Worksheet Functions	8	October 4th 05 04:37 PM
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	8	May 18th 05 04:23 AM
Count Position of Filtered TEXT cells in a column	Sam via OfficeKB.com	Excel Worksheet Functions	0	May 15th 05 08:14 PM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM
SUMPRODUCT Formula to Count Row of data Below Matched Criteria	Sam via OfficeKB.com	Excel Worksheet Functions	8	February 3rd 05 01:37 AM

All times are GMT +1. The time now is 11:33 PM.

Menu

About Us