data in a column
 

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.

data in a column
 

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.