unique rows

[gazamanga]

Hi

I'm sure there is a really easy way to do this but cannot work it out for the life of me!

I have a sheet of a few hundred rows.. many of the rows are duplicates.

I need to create a copy of this list with only unique rows - ie the duplicates removed.

Can anyone help?

Thanks in advance!

[Bryan Hessey]

Hi

I'm sure there is a really easy way to do this but cannot work it out for the life of me!

I have a sheet of a few hundred rows.. many of the rows are duplicates.

I need to create a copy of this list with only unique rows - ie the duplicates removed.

Can anyone help?

Thanks in advance!

Hi,

try Data, Filter, Advanced Filter,

select Unique, and Copy to New Location.

Let me know how you go
---

[davesexcel]

Here's a site that has a code to delete duplicate rows

http://www.cpearson.com/excel/deleting.htm

[gazamanga]

Thanks for the speedy replies guys - appreciated hugely.

Tried using the filter option first and thats worked a treat (can't believe I didn't notice it before in fact!).

Thanks very much! saved me a lot of time.

[Bryan Hessey]

Thanks for the speedy replies guys - appreciated hugely.

Tried using the filter option first and thats worked a treat (can't believe I didn't notice it before in fact!).

Thanks very much! saved me a lot of time.

good to see that it worked for you, and thanks for the response.

---