Hello,



I have a problem that is not unique I am sure.

I have a master list of customers. Most of our sales are repeat customers. However, we do get new customers each month.

I have a master list of customers that I would like to append with new customers. Sheet1 represents our master list. Sheet2 is sales to customers last month. I want to find unique names that appear on Sheet2 that are not on Sheet1 and append those names to the list on Sheet1.

I would appreciate any help.

Thanks, EdStockotn

Attached Files

Name List.xlsx (8.8 KB, 8 views)

Using the countif formula should do this (It will count how many times the value is in a range) however if this is something that you are going to running a lot it may be better to get a VBA script for it that could do it automatically for you.