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?