Exclude duplicate data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gatarossi@ig.com.br - 14 Aug 2007 00:42 GMT

Dear all,

In my column A, I have duplicate data. I known that I can use the
advanced filter and put unique values, but I need to do it with a vba
code, until now it's everything ok!

But I don't know how I will exclude the line of the duplicate data,
the advanced filter only ocult the line!

And I need that the data stay in the same column!

Thanks a lot!!!

André.

Reply to this Message

Dave Peterson - 14 Aug 2007 02:05 GMT

Is your data in one column?

If yes, then maybe you can put the output (all the unique values) of the
advanced filter into column B.

Then you could delete column A.

If your data has multiple columns, maybe you can use advanced filter for just
column A. Then copy those visible rows to a new sheet.

And if you need a macro, you could record one when you do it manually.

> Dear all,
>
[quoted text clipped - 10 lines]
>
> André.

Signature

Dave Peterson

Reply to this Message

Rate this thread: