Compare columns of numbers

  • 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
 
And when the 2 columns are compared what are the criteria for deciding which
numbers aren't required any more?
 
Assuming you want to compare col A and col B
try this in col C1
=COUNTIF($A$1:$A$10,B1)

data that appear in both col will show 1, otherwise a 0 will be shows

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
Back
Top