Exclude duplicate data

[gatarossi]

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é.

 

[Dave Peterson]

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.