Group search

[mac_see]

Groups.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	M	F	G	H	R	D	F	V	C	H	@	@	Z	S	S	D	L	K	R	F	B
2	A	D	F	T	R	E	E	E	T	Y	H	B	B	N	N	M	K	J	H	G	G
3	G	#	R	D	H	R	F	V	%	H	T	R	E	E	E	A	D	@	&	S	S
4	F	T	R	5	T	R	E	E	T	Y	D	H	R	1	V	G	H	R	D	3	F
5	E	E	T	Y	H	B	2	N	N	J	Y	Y	@	I	O	@	U	J	D	F	K
6	9	V	4	H	T	#	E	E	R	D	H	R	F	V	%	J	U	K	S	D	J
7	A	S	D	F	F	G	H	H	J	K	I	F	E	R	N	M	J	K	&	V	H
8	H	B	B	N	N	R	E	T	R	E	T	%	H	B	D	%	R	F	V	Q	4
9	T	R	E	E	E	T	3	H	B	V	C	H	T	5	Y	Y	U	I	O	Q	Z
10	&	G	H	H	J	C	H	T	R	E	T	Y	D	H	I	I	U	&	T	Z	M
Sheet1

The above table contains numbers, alphabets and special characters. I need extract groups of aphanumeric string (including special characters).

Criteria:
Every group should have 7 characters
That group should have repeated somewhere atleast once. Example: "R D H R F V %" was repeated twice in the entire table.

 

[jdc]

Hi

Are these groups purely starting at a cell and reading from left to right, or like the "find-the-words" game that run horizontally, vertically and diagonally.

And what are the maximum number of cells across and down of your searchable range.

John

 

[jdc]

The Groups that match start at cells D3 and at J6,
I had to do a workaround to get the results, but now can do the task
a lot quicker now that the hardwork is done.

Assuming you're only doing string searches in a left -to-right direction.
Is this correct

John

 

[mac_see]

Yes, I need to make my search in left-to-right direction

Maxi