leigh_ashlin
Board Regular
- Joined
- Feb 9, 2005
- Messages
- 74
Hi there, can somebody write me a piece of fandango vb that is smart enough sort two lists of numbers and create gaps where there are numbers that do not match in either column?
This would be my raw data:
And this would be the expected result:
Alternatively, is there a fancy expression that can do this?
This would be my raw data:
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 1 | 1 | ||||
2 | 2 | 2 | ||||
3 | 3 | 4 | ||||
4 | 4 | 5 | ||||
5 | 7 | 6 | ||||
6 | 8 | 8 | ||||
7 | 9 | 9 | ||||
Sheet1 |
And this would be the expected result:
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 1 | 1 | ||||
2 | 2 | 2 | ||||
3 | 3 | |||||
4 | 4 | 4 | ||||
5 | 5 | |||||
6 | 6 | |||||
7 | 7 | |||||
8 | 8 | 8 | ||||
9 | 9 | 9 | ||||
Sheet1 |
Alternatively, is there a fancy expression that can do this?