filtering problems
 

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.

filtering problems
 

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",COUNT IF($H$1:H1,B1&"|"&C1))
and copy down as far as required
--
Regards
Roger Govier

"KW" wrote in message
...
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.