| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How many new customers every month?
I have the following situation.
Customer Date 123 12/11/2003 534 13/11/2003 654 04/12/2003 123 14/12/2003 I want to know have many NEW customers I have every month? How to do this with a macro? -- -- Jan United Kingdom, London |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How many new customers every month?
In a new column
=IF(COUNTIF(A$1:A100,A101),"","New") would identify if the customer is new. Jerry Jan wrote: I have the following situation. Customer Date 123 12/11/2003 534 13/11/2003 654 04/12/2003 123 14/12/2003 I want to know have many NEW customers I have every month? How to do this with a macro? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count my Customers | Excel Worksheet Functions | |||
| Sum customers by date | Excel Discussion (Misc queries) | |||
| How many different customers in a list? | Excel Worksheet Functions | |||
| What is the best template to use to keep a log of the customers I. | Excel Worksheet Functions | |||
| Top 5 customers | Excel Programming | |||
![Jan[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
