Hi All,
I have a range which V12:V18, data consistantly changes and there
might be some duplications. I would like to find the duplicated data
and just clear the duplications without deleting any row. Because
those rows effecting other formulas.Is that possible?
Thanks
\\

Baha

;562078 Wrote:
Hi All,
I have a range which V12:V18, data consistantly changes and there
might be some duplications. I would like to find the duplicated data
and just clear the duplications without deleting any row. Because
those rows effecting other formulas.Is that possible?
Thanks
\\

Baha
Sub blah()
Set Rng = Range("V12:V18")
For Each cll In Rng
If Application.WorksheetFunction.CountIf(Rng, cll.Value) 1 Then
cll.Value = Empty
Next cll
End Sub


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=155056

Microsoft Office Help

Thank you very much, it works for me very well.
Have a good day
Baha