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

K

Kelvin yu

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
 
D

Dave Peterson

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","Unique")
 
B

Biff

Maybe this:

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

A result that is >0 means there are duplicates.

Biff
 
K

Kelvin yu

Should be the whole R.
Anyways, i figured out the silly thing i have made here
If they are duplicated, they will be shown on the first data anyway.
thanks Dave
 
Top