LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 73
Default Count Customers by Account Size

I have a listing of thousands of customers and need to count how many fall
into specific groups based on the size of the account (how much we sold to
them).

Example of desired result:

<$100K - 50 customers
$100K - 80 customers
$200K - 100 customers
$300K - 90 customers
$400K - 60 customers


How would you approach?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 my Customers DaveMoore Excel Worksheet Functions 4 January 19th 10 08:31 PM
account # entry needs to return the account description placerpone Excel Worksheet Functions 1 November 9th 09 03:02 AM
Count number of 2008 invoices for customers Pierre Excel Worksheet Functions 2 September 5th 08 04:32 PM
top ten customers by transaction count by product Carl Excel Worksheet Functions 2 September 25th 06 09:31 PM
Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? Divya Sanam Excel Discussion (Misc queries) 0 July 20th 06 05:15 PM


All times are GMT +1. The time now is 09:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"