I need a formula for Cell G2 that will read the digits in Col's B2:F2 and tell what group they came from. It's possible to have all 5 digits come from one group. I hope you will be able to understand what I'm trying to accomplish. I entered some examples that the results should like, I have no idea where to start with this. Thanks for all suggestions.
Carbob
PS: I just caught an error G2, it should be 1EE2EO3O
Group 1
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 Even 2, 4, 6, 8, 10, 12 ODD 1, 3, 5, 7, 9, 11
Group 2
13 ,14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24 Even 14, 16, 18, 20, 22, 24 ODD 15. 17, 19, 21, 23
Group 3
25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36 Even 28, 30, 32, 34, 36, ODD 27, 29, 31, 33, 35
Carbob
PS: I just caught an error G2, it should be 1EE2EO3O
Group 1
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 Even 2, 4, 6, 8, 10, 12 ODD 1, 3, 5, 7, 9, 11
Group 2
13 ,14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24 Even 14, 16, 18, 20, 22, 24 ODD 15. 17, 19, 21, 23
Group 3
25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36 Even 28, 30, 32, 34, 36, ODD 27, 29, 31, 33, 35
F5 VTRACS V1.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | |||
2 | 4 | 8 | 14 | 21 | 27 | 1E2EO3O | |||
3 | 10 | 16 | 18 | 25 | 30 | 1E2EEO3E | |||
4 | 3 | 8 | 17 | 20 | 30 | 1EO2OE3E | |||
5 | 1 | 6 | 7 | 17 | 34 | ||||
6 | 17 | 25 | 32 | 35 | 36 | ||||
7 | 9 | 13 | 23 | 25 | 29 | ||||
8 | 1 | 17 | 18 | 31 | 32 | ||||
9 | 13 | 16 | 21 | 28 | 29 | ||||
10 | 4 | 6 | 11 | 26 | 32 | ||||
11 | 4 | 17 | 19 | 34 | 36 | ||||
12 | 5 | 19 | 24 | 31 | 35 | ||||
13 | 1 | 5 | 21 | 23 | 34 | ||||
Sheet1 |