Does anyone know if there is a symbol for the "except" in formula?
 

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

Does anyone know if there is a symbol for the "except" in formula?
 

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

Does anyone know if there is a symbol for the "except" in formula?
 

Maybe this:

=COUNTIF($R$2:$R$15874,R2)-1

A result that is 0 means there are duplicates.

Biff

"Kelvin yu" wrote in message
...
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