duplicates

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a spreadsheet with part numbers in columns A and B (38,856 in
column A and 49,623 in column B), and I would like to check the
numbers in column A against the numbers in column B and see if there
are any duplicates. Is this possible and if so, how can this be done?

Thanks,

Tom
 
One way
in col C or H or X
=if(a1=b1,0,1) and sort on that col.
or a for/each loop
if c=c.offset(,1) then do what
 
Tom,

In a third column and in the first row use the formula
=CountIf(B:B,A1)
fill this down.
The result will be the count of the part number in column A that appear in
column B.

steve
 
Back
Top