duplicate data in range clear contents
 

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

duplicate data in range clear contents
 

;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

duplicate data in range clear contents
 

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