How to delete redundant info/data rows

**gendis** · 12-05-2007, 03:59 PM

I have a long list that I have sorted. There are over 59,000 rows. I am trying to compile a list of what I have. There are only about 2700 unique entries in my list.

How do I sort or get rid of all the redundant entries in my one column?

I need to be able to copy and paste or save this compiled list for use in another application that imports TXT's files and CSV files.

My example has been attached.

Thanks in advance.

GenDis

**Ron Coderre** · 12-05-2007, 04:05 PM

There are several approaches to your issue.
This one may be the most efficient and least duration to run:

Assuming your 59,000 row data list has Column Headings (eg Date, Name, etc).

Copy those headings off to the right of the data.
Select the original list, including headings.

Then....from the Excel Main Menu
<data><filter><advanced filter>
...Check: Copy to another location
...Check: Unique records only
...Copy to: (select the titles you pasted off to the right)
Click [OK]

Now you'll have a list of only the unique values.

Is that something you can work with?
Post back if you have more questions.