I have a simple formula that I would like incorporate into my vba to loop through the document but it does seem to work.

=IF(COUNTIF($C$1:C20,C20)=1,C20," ")

ActiveCell = "=If(Countif($R[0]$C[1]:R[0]C[1],R[0]C[1])=""1"",R[0]C[1],"" "")"

Thanks in advance.