Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is de-duping in advanced filter limited to a number of rows
I am using the advanced filer in excel to remove duplicates from my data set.
The function works OK for a few hundred rows. It does not work for 1500 rows. I would like to use it for a data set of 12000 rows. Is this function limited to a number of rows? If so, is there anothe way to de-dup 12000 rows |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is de-duping in advanced filter limited to a number of rows
AutoFilter is limited to showing the first 1,000 unique entries in its
drop-down list. To de-dupe another way, use another column for a COUNTIF function. In it put =IF(COUNTIF($A$1:A1,A1)1,"X","") and drag down to copy to the end of your list (assuming your list is in column A). Now autofilter on that column for X to get duplicates and delete them, or Autofilter on blanks to get the uniques and copy them elsewhere. HTH DOR |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is de-duping in advanced filter limited to a number of rows
Not to my knowledge, I have used advanced filter on plus 20000 rows
and it works fine, note that if you do it in place you are not removing any duplicates you are just hiding the rows with the duplicates. I always use copy to another location that way I get a list without hidden rows -- Regards, Peo Sjoblom "Sully" wrote in message ... I am using the advanced filer in excel to remove duplicates from my data set. The function works OK for a few hundred rows. It does not work for 1500 rows. I would like to use it for a data set of 12000 rows. Is this function limited to a number of rows? If so, is there anothe way to de-dup 12000 rows |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete rows based on multiple criterias | Excel Discussion (Misc queries) | |||
Is there an easy way to filter duplicate rows of data in excel? | Excel Discussion (Misc queries) | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Insert a number of rows based on a value in a cell on active row | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |