Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering | Excel Discussion (Misc queries) | |||
Filtering | Excel Discussion (Misc queries) | |||
Excel 2003 filtering problems | Excel Worksheet Functions | |||
Filtering ? | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |