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
---------------
Jacob Skaria


"Dave T" wrote:

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