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