Check for duplicates

[Pat]

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

 

[Bob Phillips]

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]

Hi Bob,
V304& " " &W304& " " &X304 is being compared.

 

[Bob Phillips]

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]

=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]

Pat,

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

--

HTH

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

 

[Pat]

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

Pat

 

[Bob Phillips]

Pat,

Yes, it would be a very good alternative. You can refer to the cell itself
in CF. Do you need help, or are you au fait with the technique.

--

HTH

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

 

[Pat]

Bob,
I will try first giving it a go myself.
Cheers
Pat