Matching values in different cells

C

Carlos

Hello,

I have 2 sets of numbers, 1 set is found in Column A and
the other set is in Column D. I want to compare both
columns and it to return the values in Column A that arent
in column D.

Currently there are about 1000 records in column A but
only 600 in column D. I need to know what the 400 records
are.

Thanks in advance
 
R

richard daniels

Hi

enter this formula in a cell b1

=IF(ISERROR(MATCH(A1,$D$1:$D$7,0)),"Missing","")

the formula will match the value of A1 in the range
D1:D7 if the value is not found then 'missing'
 

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

Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
Macro for comparing columns and highlighting matching/differences 13
Word macro that can call cells out of Excel for a find and replace 0
Sum Values from different column 1
Excel VBA macro, search - accumulate - delete original 0
Extracting a cell value 2
Refewrence tables 2
Macro to change referenced column to the next one 1

Top