Comparing columns

  • Thread starter Thread starter Dave T
  • Start date Start date
D

Dave T

I am trying to compare 2 columns of numbers so that I can identify and
delete numbers no longer required. Can anyone help me find a formula for
this please?

Many thanks
DT
 
Suppose you are comparing ColA and ColB. In Col C use the below formula

This will compare the entry in B1 aganist column A and if found return
"Found" or else "Not Found"

In C1 use the below formula and copy down as required.

=IF(COUNTIF(A:A,B1)>0,"Found","Not found")

If this post helps click Yes
 
Back
Top