Use
=IF(COUNTIF($R$6:R6,R6)=1,R6,"")

and copy down till R533 (when you copy down R6 will change to R7, R8 and so
on)

For the current row, it counts the number of times the value in Col B for
that Row occurs from R6 till current row, and replaces it with "" if the
count is more than 1.
"evoxfan" wrote:

I must be doing something wrong.

This is the formula I entered. =IF(COUNTIF($R$6:R533,R6)=1,R6,"")

The result is a blank; it does not show the first occurrence.

How can I correct?


"Sheeloo" wrote:

If you have your numbers in Col A then enter this formula in B1 and copy down
till end of your data set..
=IF(COUNTIF($A$1:A1,A1)=1,A1,"")

It will replace duplicate numbers with blank except for the first occurence.

"evoxfan" wrote:

I have a column of numbers such as:
190.000
190.000
194.000
580.000
910.000
910.111
910.130
I want to delete the numbers that are repeated.

What is the best way to accomplish this?