Start at $r$3???

=ISNA(MATCH(R2,$R$3:$R$15874,FALSE))

But if you're going to copy this down the column, this won't work.

Maybe you could just use:

=if(countif($r$2:$r$15874,r2)1,"duplicated","Uniq ue")

Kelvin yu wrote:

I am now trying to find out the duplicated data in the same colume and i use
the following formulas except i don't know how to add condition to the look
up array since i don't want to compare the data with itself, can anyone help?
=ISNA(MATCH(R2,$R$2:$R$15874,FALSE))
^ I want to exclude R2 itself or it will
give wrong result.

Thanks
--
Kelvin Yu

--

Dave Peterson