Need data where ever we get all the letters

[sksanjeev786]

Hi Team,

I need a data if that cell has all the letters based on row 2 ie. "'56 BCDEFGHIJKLMNOP" has all the letters except Colunm A need to highlight or pull the data in a separate cell

same for '48 ACDEFGHIJKLMNOP except for column B (Based on row 2 )

book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
2		A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
3
4	TBCA	56 BCDEFGHIJKLMNOP	43 FGHIJKLMNOP	42 FGHIJKLMNOP	40 FGHIJKLMNOP	39 FHIJKLMNOP	29 HIJKLMNOP	34 FHIJKLMNOP	22 IKLMNOP	15 LMP	18 KLMNOP	14 P	11	11	14 P	13	10
5	Unaided Awareness	38 CDFGHIJKLMNOP	48 ACDEFGHIJKLMNOP	21 HIJKLMNOP	24 HIJKLMNOP	42 CDFGHIJKLMNOP	28 CHIJKLMNOP	32 CDHIJKLMNOP	12 IJKLMNOP	7 JKLMNOP	4 MNOP	4 MNOP	3 MOP	1	2	1	1
6	Consideration (Top 2 Box)	60 CDEFGHIJKLMNOP	59 CDEFGHIJKLMNOP	45 GHIJKLMNOP	49 FGHIJKLMNOP	46 FGHIJKLMNOP	40 HIJKLMNOP	38 HIJKLMNOP	26 IJLMNOP	21 LMNOP	21 LMNOP	22 LMNOP	14	13	15	15	13
Sheet1

 

[Peter_SSs]

Is this Conditional Formatting what you mean?

24 08 13.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
2		A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
3
4	TBCA	56 BCDEFGHIJKLMNOP	43 FGHIJKLMNOP	42 FGHIJKLMNOP	40 FGHIJKLMNOP	39 FHIJKLMNOP	29 HIJKLMNOP	34 FHIJKLMNOP	22 IKLMNOP	15 LMP	18 KLMNOP	14 P	11	11	14 P	13	10
5	Unaided Awareness	38 CDFGHIJKLMNOP	48 ACDEFGHIJKLMNOP	21 HIJKLMNOP	24 HIJKLMNOP	42 CDFGHIJKLMNOP	28 CHIJKLMNOP	32 CDHIJKLMNOP	12 IJKLMNOP	7 JKLMNOP	4 MNOP	4 MNOP	3 MOP	1	2	1	1
6	Consideration (Top 2 Box)	60 CDEFGHIJKLMNOP	59 CDEFGHIJKLMNOP	45 GHIJKLMNOP	49 FGHIJKLMNOP	46 FGHIJKLMNOP	40 HIJKLMNOP	38 HIJKLMNOP	26 IJLMNOP	21 LMNOP	21 LMNOP	22 LMNOP	14	13	15	15	13
Check letters

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:Q6	Expression	=COUNT(FIND($B$2:$Q$2,B$2&B4))=COLUMNS(B$2:Q$2)	text	NO

 

[sksanjeev786]

Is this Conditional Formatting what you mean?

24 08 13.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
2		A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
3
4	TBCA	56 BCDEFGHIJKLMNOP	43 FGHIJKLMNOP	42 FGHIJKLMNOP	40 FGHIJKLMNOP	39 FHIJKLMNOP	29 HIJKLMNOP	34 FHIJKLMNOP	22 IKLMNOP	15 LMP	18 KLMNOP	14 P	11	11	14 P	13	10
5	Unaided Awareness	38 CDFGHIJKLMNOP	48 ACDEFGHIJKLMNOP	21 HIJKLMNOP	24 HIJKLMNOP	42 CDFGHIJKLMNOP	28 CHIJKLMNOP	32 CDHIJKLMNOP	12 IJKLMNOP	7 JKLMNOP	4 MNOP	4 MNOP	3 MOP	1	2	1	1
6	Consideration (Top 2 Box)	60 CDEFGHIJKLMNOP	59 CDEFGHIJKLMNOP	45 GHIJKLMNOP	49 FGHIJKLMNOP	46 FGHIJKLMNOP	40 HIJKLMNOP	38 HIJKLMNOP	26 IJLMNOP	21 LMNOP	21 LMNOP	22 LMNOP	14	13	15	15	13
Check letters

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:Q6	Expression	=COUNT(FIND($B$2:$Q$2,B$2&B4))=COLUMNS(B$2:Q$2)	text	NO

Perfect!! thank you so much Peter

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.