How delete rows duplicated???

[Wilmarjr]

I work with worksheet with 6.000 rows, sometimes I have to delete duplicate rows. How can I delete all those duplicates at once? Or any formula that make easy to delete??
Because right now I have to go line by line and this is take to long to do!!

Thanks for everyone that will try to help me!

[olasa]

The easiest way is to use Advanced Filter and select only Unique items. Done in no time.
This video can show how. Fast forward to 3:40. http://www.datapigtechnologies.com/f...utofilter.html

Hope it helped
Ola Sandtröm

[Amir_P]

The easiest way is to use Advanced Filter and select only Unique items. Done in no time.
This video can show how. Fast forward to 3:40. http://www.datapigtechnologies.com/f...utofilter.html

Hope it helped
Ola Sandtröm

It Was Fascinating. Thanks Ola