Filtering for unique records (Excel 2007)

G

gcotterl

COL A has 100,000 cells.

Some data is contained in only one cell while other data is contained
in more than one cell.

To get a list of the cells containing unique data, I click DATA> SORT>
FILTER> ADVANCED and select "Unique Records Only" check box and click
OK but, TWO hours later, Excel is still processing. What am I doing
wrong?
 
Top