Please help: How to delete double data (rows)

[bartvw]

I have an excel worksheet (Excel 2007) where I have around 4000 rows of data.

So now and then there are double rows, so similar rows are shown.

Instead of deleting the manually I want to find out how I can delete more easily.

Which formula can I use to automatically delete this double data?

I sincerely appreciate your time to answer this question.

Bart.

 

[VoG]

Take a look at Data > Remove Duplicates.

Edit: see http://www.mrexcel.com/tip138.shtml

 

[bartvw]

Thanks for your advice.

I have tried to use the path "data" > "advanced" > etc. but this only seems to work with one column.

So I select more columns, in my case, A:AG, then I tick a new column in the same worksheet where the filtered data should come and then it gives the data, but instead of showing only unique data (even though I ticked "Unique records only".
Just like here: http://www.contextures.com/xladvfilter01.html#FilterUR

What goes wrong??