Duplicate numbers

[oleg_v]

Hi
i need a help with a macro
that will find duplicated numbers in sheet2 column "r"
than delete one of then no meter witch one

thanks

[mikerickson]

Have you looked at AdvancedFilter?

[oleg_v]

hi
thanks
it works but how i delete hidden rows ofter advanced filter

[mikerickson]

Did http://www.excelforum.com/excel-programming/730830-dupluicate-numbers.html help?

[Aussiebear]

Oleg,

Cross posting on an issue is highly disrespectful to those members of either forum, particularly when you don't post the link as well.

A 7 day ban has been applied to you. When you return to this web site I hope that you understand that should this occur again, a far lengthier period will be applied.

This message would have been sent to you privately but you have elected not to have recieved PM's from Administration