Matching values in different cells

  • Thread starter Thread starter Carlos
  • Start date Start date
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
 
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'
 
Back
Top