How good is your example?

1. I can see that the Green is acceptable -- G<H<I<J<K<L

2. I can see that the Orange is not acceptable -- G>H

3. Where did the Blue come from?

Capture.JPG


Lets say columns A-F contain numbers. I want to generate all the combination of these 6 columns without repetition and considering the criteria below for generated combination (assuming the combinations are stored in COLUMNS G-L): G<H<I<J<K<L
I don't see where 'All Combinations' comes in

For example

1 10 24 39 45 55


can be arranged 720 ways (6!) and there's only 1 way G<H<I<J<K<L


Likewise

9 6 20 40 41 51

can be arranged 720 ways and 6-9-20-40-41-51 would be the answer

It sort of / almost / kind of looks like you just want to take 6 numbers and see if G<H<I<J<K<L, returning a Yes/No answer