I would suggest using the Chip Pearson methodology for extracting unique
entries from a list (which he refers to as 'Listing Distinct Elements In A
List.') I've used it before and it works like a charm!!
http://www.cpearson.com/excel/ListFunctions.aspx
Good luck!
"ABCD" wrote:
> I have data in an excel spreadsheet. In one column, I have repeatative
> entries. For example, the column looks like
>
> aaaa
> bbbb
> aabb
> aaaa
> bbbb
>
> etc.
>
> The problem is that the column has some 20000 rows, and I need to find these
> type of entries that are repeating again and again. For example in the above
> case, what I am looking for is "aaaa, bbbb, aabb" that is all. In my real
> example, I might have some 40 or 50 such different entries. It will take me
> hours to go thru the column and find those. Plus manual error will be
> unavoidable.
>
>
>
