| 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 |
|
#7
|
|||
|
|||
|
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 |
|
#8
|
|||
|
|||
|
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" wrote in message ... 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 |
|
#9
|
|||
|
|||
|
Bob,
I will try first giving it a go myself. Cheers Pat "Bob Phillips" wrote in message ... 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" wrote in message ... 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 |
| 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 | |||
Linear Mode
