How many new customers every month?

  • Thread starter Thread starter Jan
  • Start date Start date
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?
 
In a new column

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

would identify if the customer is new.

Jerry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find then highlight in yellow 6
How do I set auto-sort for a column in a worksheet? 6
Combining Multiple Rows of Data in Excel 4
Autofil on variable rows, delete extract and show remaining rows 3
Add Hours by Looping through Data Q 27
How to export table from outlook into ms access table? 0
Gears 14
macro adding rows 8

Back
Top