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.