Column comparison

[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

 

[Dave Peterson]

Chip Pearson has lots of techniques for working with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx

=isnumber(match(a1,sheet2!a:a,0))

will return True if the value in A1 (of sheet1) matches any value in column A of
sheet2.

 

[Dave T]

Many thanks for your help it is much appreciated.

DaveT