Finding a list of customers who are in column D but not in column A

[tech1444]

I am tasked to find a list of all of our customers who purchased from us in 2014 (Column D) and who are not in column A (those customers who have purchased this year). I'd be happy with any one of the following:

• Highlight the cell in column D of any customer who hasn't purchased this year.
• Place some type of mark (i.e. ".") in column C of any customer who hasn't purchased this year
• Create separate list in columns G-H that will include the name of the customer from column D and the corresponding sales total from column E

Any help would be much appreciated.

 

[bbott]

Welcome to the board.

There's a number of ways to accomplish your goal. Using the formula approach, enter this in C1:

=IF(COUNTIF(A:A,D1),"duplicate","")

and copy down. It will show you which customers are in both columns.

 

[tech1444]

Thanks for the quick response. I'm getting a strange thing that sometimes happens to me but not enough that I can figure out why it's happening. I entered the formula, but all I get is the exact text of the formula showing up instead of a result. I also made a slight variation to your formula. Row 1 is actually my header row, so I changed the formula accordingly and placed it in C2:

==IF(COUNTIF(A:A,D2),"duplicate","")

What am I doing wrong?

 

[bbott]

Make sure that there is not a space before the = and that there is only one =.

 

[tech1444]

Make sure that there is not a space before the = and that there is only one =.

Thanks so much. That worked.

 

[bbott]

Thanks so much. That worked.

You're welcome.