How many new customers every month?

J

Jan

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?
 
J

Jerry W. Lewis

In a new column

=IF(COUNTIF(A$1:A100,A101),"","New")

would identify if the customer is new.

Jerry
 
Top