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

tech1444

New Member
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.

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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.

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?

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

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

Thanks so much. That worked.

Replies
0
Views
526
Replies
10
Views
507
Replies
0
Views
247
Replies
3
Views
396
Replies
0
Views
829

Threads
1,203,465
Messages
6,055,574
Members
444,799
Latest member
CraigCrowhurst

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back