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

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?