| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Check for duplicates
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
=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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| Auto spell check as in word | Excel Discussion (Misc queries) | |||
| check box formatting | Excel Discussion (Misc queries) | |||
| Using a Check Box as a control item | Excel Discussion (Misc queries) | |||
| Creating a check box that does not require security clearance. | Excel Worksheet Functions | |||
Hybrid Mode
