AlanY
Well-known Member
- Joined
- Oct 30, 2014
- Messages
- 4,528
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
this is the question posted by another member in "Questions in Other Languages"
https://www.mrexcel.com/forum/questions-other-languages/1099110-extract-tail-tail-combination.html
that I'd translated here
the last digit of any pairs of numbers in A:F matched the last digit in G, merged the said pairs' last digit into H and so on, e.g.
https://www.mrexcel.com/forum/questions-other-languages/1099110-extract-tail-tail-combination.html
that I'd translated here
the last digit of any pairs of numbers in A:F matched the last digit in G, merged the said pairs' last digit into H and so on, e.g.
Book1 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
10 | 101 | 102 | 103 | 104 | 105 | 106 | 103 | 12 | ||||
11 | 101 | 102 | 103 | 104 | 105 | 106 | 108 | 26 | 35 | |||
12 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 16 | 25 | 34 | ||
Sheet4 |
Last edited: