serge
Well-known Member
- Joined
- Oct 8, 2008
- Messages
- 1,446
- Office Version
- 2007
- Platform
- Windows
I need a CF formula to solve the highlighting in the yellow table on the right, I had a similar post before which I tried to used the formula from it but doesn't work !!! so if someone can help ?
Thank you.
Thank you.
Excel Workbook | |||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | |||
1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Arrange from. | ||||||||||||||||
2 | |||||||||||||||||||||||||||||||||||||
3 | 7 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 2 | 1 | 4 | 6 | 7 | 18 | 8 | 69 | 100 | 100 | 1 | 2 | 4 | 6 | 7 | 8 | 18 | 69 | 100 | 100 | ||||||
4 | 0 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 3 | 2 | 5 | 7 | 8 | 19 | 9 | 1 | 101 | 101 | 1 | 2 | 3 | 5 | 7 | 8 | 9 | 19 | 101 | 101 | ||||||
5 | 1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 1 | 3 | 6 | 8 | 9 | 20 | 10 | 2 | 102 | 102 | 1 | 2 | 3 | 6 | 8 | 9 | 10 | 20 | 102 | 102 | ||||||
6 | 5 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 2 | 1 | 7 | 9 | 10 | 21 | 11 | 3 | 103 | 103 | 1 | 2 | 3 | 7 | 9 | 10 | 11 | 21 | 103 | 103 | ||||||
7 | 3 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 3 | 2 | 8 | 10 | 11 | 1 | 12 | 4 | 104 | 104 | 1 | 2 | 3 | 4 | 8 | 10 | 11 | 12 | 104 | 104 | ||||||
8 | 4 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 4 | 3 | 9 | 1 | 12 | 2 | 13 | 5 | 105 | 105 | 1 | 2 | 3 | 4 | 5 | 9 | 12 | 13 | 105 | 105 | ||||||
9 | 4 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 5 | 4 | 10 | 2 | 1 | 3 | 14 | 6 | 106 | 106 | 1 | 2 | 3 | 4 | 5 | 6 | 10 | 14 | 106 | 106 | ||||||
10 | 1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 6 | 5 | 11 | 3 | 1 | 4 | 15 | 7 | 107 | 107 | 1 | 3 | 4 | 5 | 6 | 7 | 11 | 15 | 107 | 107 | ||||||
11 | 1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 7 | 1 | 12 | 4 | 2 | 5 | 16 | 8 | 108 | 108 | 1 | 2 | 4 | 5 | 7 | 8 | 12 | 16 | 108 | 108 | ||||||
12 | 0 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 8 | 1 | 13 | 5 | 3 | 6 | 17 | 9 | 109 | 109 | 1 | 3 | 5 | 6 | 8 | 9 | 13 | 17 | 109 | 109 | ||||||
13 | 1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 1 | 2 | 14 | 6 | 4 | 7 | 18 | 10 | 110 | 110 | 1 | 2 | 4 | 6 | 7 | 10 | 14 | 18 | 110 | 110 | ||||||
14 | |||||||||||||||||||||||||||||||||||||
Sheet3 |