I need a formula that will spot duplicate reference diesignator's such as if
you have mo9310 more than once, the cell will say ref! or change color.

=IF(COUNTIF($A$2:A2,A2)1,"Duplicated","")

"Michaela" wrote:

I need a formula that will spot duplicate reference diesignator's such as if
you have mo9310 more than once, the cell will say ref! or change color.

another choice
u also can use Data formatting to change the color
i.e table_array:range("a1:a10")
choose a1data formattingcell value "=countif($a$1:$a1,a1)<1" set the
color then drop down(just copy the format)

PS.while u use the excel 2007 it will be more easy cas it privide this
rules.



"Michaela" ...
I need a formula that will spot duplicate reference diesignator's such as
if
you have mo9310 more than once, the cell will say ref! or change color.