Filtering and cleaning data

[cdb15]

Hi guys,

First question on here as this is my first time dealing with heaps of data.
I currently have 20,000 rows of data (which I have filtered down from 600,000) and I have noticed that as I read down the page, some rows are repeated after each other (some more than once). For example I have October price data for every year from 1995-2005 on every stock on a particular stock exchange (so it is sorted according to company name) however some identical observations seem to be repeated between two and ten times.

Wondering if anybody knows if there is a quick way to go through every row and delete any rows that are repeated (so if there are 10 of the exact same row, I delete 9 of them and just have the one left).

Cheers and hope my question makes sense. Forgive me if it is a simple thing I have missed, I am still working on my excel skills.

[martindwilson]

there is a remove duplicates option in excel 2007
http://www.mrexcel.com/tip138.shtml
several methods are shown but scroll down to
Method 5: New in Excel 2007 - Use Remove Duplicates icon
but practice on a copy first!