Find if part of a cell is correct

**noobsaibot** · 07-15-2016, 01:57 PM

I had made this a while ago but can't figure out how to do it now.....

If a text in a cell is composed of multiple parts (i.e. bar code), how do I condition the cell to highlight the incorrect code, if the character combination does not exist for that segment.

So if I have;

Segment 1: A, B, C
Segment 2: D, E, F
Segment 3: GHI, JKL
Segment 4: MNO, PQR
Segment 5: STU, VWX
Segment 6: YZ1

Correct Code Combination: ADGHIMNOYZ1
Incorrect Code Combination: ADMNOGHIYZ1

**FlameRetired** · 07-18-2016, 12:44 AM

Not sure I have interpreted correctly. I "forced" a combination I thought would be correct in row 6. Array enter in D1 and fill down.

Formula:

Please Login or Register  to view this content.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Row\Col	A	B	C	D	E
1	A	B	C	Incorrect	=IF(COUNT(FIND(IF(A1:C1<>"",A1:C1),"ADGHIMNOYZ1"))=SUM(COUNTIF(A1:C1,"<>")),"Correct","Incorrect")
2	D	E	F	Incorrect
3	GHI	JKL		Incorrect
4	MNO	PQR		Incorrect
5	STU	VWX		Incorrect
6	YZ1	ADG		Correct