LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default Filter out unique additions month to month

My goal is to demonstrate how many NEW customers are added each month. So if
a customer existed in January and also existed in February, they would only
be counted in the January total. If a customer appeared in March and not the
previous months then it would be counted only in March and not future months.
I am basically trying to determine the acceptance of a particular service.

I have two columns; one that has customer id and the other the month they
appeared. I know a long way to get what I want but am looking for a more
efficient method.



 
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
Excel 2003 month to month data change grid Chad[_2_] Excel Discussion (Misc queries) 2 February 15th 08 01:36 AM
Filter by month, then day, not just day honyacker Excel Discussion (Misc queries) 1 March 21st 07 06:16 PM
Need to filter by month mikeybmdb Excel Discussion (Misc queries) 3 November 1st 05 01:53 PM
transfer cell $ amount to other sheet month-to-month without overc Colin2u Excel Discussion (Misc queries) 1 July 28th 05 02:36 AM
Filter by month Marci Excel Discussion (Misc queries) 3 January 10th 05 05:53 AM


All times are GMT +1. The time now is 09:00 AM.

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"