filtering problems

  • Thread starter Thread starter KW
  • Start date Start date
K

KW

I have a worksheet with three columns and thousands of rows. I am trying to
find 250 duplicates within 46000 rows. Seems like a piece of cake until you
factor in an ID number that makes every row unique. I need to make a list of
all the duplicates. Here is an example of the data.....
7114 187501 42939
17858 187501 42939
22526 187501 42940
20705 187501 42940
14967 187501 42941
17129 187501 42941
19658 187501 42942
3652 187501 42942

Can anyone help?? Thanks in advance.
 
Hi

It depends whether you are after Duplicates in columns B and in Column C or
in B&C combined.
If the former, then in D1 enter
=IF(COUNTIF($B$1:B1,B1)>1,"Duplicate",COUNTIF($B1:B1,B1))
and in E1 enter
=IF(COUNTIF($B$1:C1,C1)>1,"Duplicate",COUNTIF($B1:C1,C1))
and copy down as far as required

If it is B&C then in D1 enter
=B1&"|"&C1
in E1 enter
=IF(COUNTIF($H$1:H1,B1&"|"&C1)>1,"Duplicate",COUNTIF($H$1:H1,B1&"|"&C1))
and copy down as far as required
 
Back
Top