Compare values of two columns

D

Diane

Group,
I have duplicate customer numbers in column1, I then filter this column for
unique records and placing in column 3. Column 1 contains 1661 rows, column
3 contains 1492 rows, now I want to create a formula in column 5 that
compares 1 from 2 and lists the missing numbers. I know this is a simple
formula, can someone get me started?
Thanks,
 
R

ryguy7272

Maybe you can try something like this:
=IF(COUNTIF($B$1:$B$20,$A$1:$A$20)>0,B1,"")

Regards,
Ryan---
 
M

Marcelo

Thank you for your feedback
happy to help

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Diane" escreveu:
 

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

OR Exact statement not working to compare values in two columns 4
Need array formula to ignore hidden values 1
Match and delete rows on two different sheets from reference numbers 4
count unique values if 2 variables 6
Comparing data in two columns 1
counting unique items(values or text) 14
What type of "lookup" 3
VLookup 15

Top