Bob,
Perhaps that's is the way to do it. On the otherhand would using conditional
formatting be an alternative method?

Pat

"Bob Phillips" wrote in message
...
Pat,

You just can't do that, put a formula in a cell that references that cell.
Can they not go in D77:D1000?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pat" wrote in message
...

=IF(AND(V304="",ISNUMBER(MATCH("2"&" " &V304& " " &W304& " "
&X304,C77:C1000,0))),"2"&" " &V304& " " &W304& " " &X304,"")

Bob,
This creates a circular reference. I will be using the formula in every
cell
from C77:C1000
I have entered it first into C77:

=IF(AND(V77="",ISNUMBER(MATCH("2"&" " &V77& " " &W77& " "
&X77,C77:C1000,0))),"2"&" " &V77& " " &W77& " " &X77,"")

Pat



"Bob Phillips" wrote in message
...
Pat,

I think this is probably what you want

=IF(AND(V304="",ISNUMBER(MATCH("2"&" " &V304& " " &W304& " "
&X304,C7:CF1000,0))),"2"&" " &V304& " " &W304& " " &X304,"")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pat" wrote in message
...
Hi Bob,
V304& " " &W304& " " &X304 is being compared.


"Bob Phillips" wrote in message
...
what result is being compared, the spaces, V304, or the concatenated
value
(Or any)?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pat" wrote in message
...

The following formula is contained in C304

=IF(V304="","","2"&" " &V304& " " &W304& " " &X304)

I need to include into the formula a way to check if the result is
a
duplicate of another result in column C.
The range covers from C77:C1000.

Thank you if you can help.
Pat