Show all possible combinations

[Havre]

Hi

How do i show all possible combinations from three columns in a specific order (Excel 2013), shown below? I only wish to show the combinations where the number from column A is lower than B and B is lower than column C.

Ex.

A B C D
1. 6 6 1, 6, 8 OK
2 7 8 1, 6, 6 Not ok
3. 8. 9. 1, 9, 6 Not ok
4. 9. 10
5. 10. 11
6. 11. 12
7. 12. 13

I'm no pro just an amateur trying to leran.

[Special-K]

It's not clear from your definition or example what the cells contain.

What does A1 contain?
Is it 6
Or 6 6 1?
Or even 661?
Or maybe something else entirely?

From your definition
=IF(AND(A1 < B1, B1 < C1),"","Not")&" OK"
shoyuld suffice but that depends on your data as requested above.

[Havre]

Forget abort the picture, it got all wrong.

I wish to show all possible combinations from a range of three columns A, B and C. Lets say that the range in A is 1-10, B 5-15 and C 10-20. I only want to show the combinations where the number from A is lower than B and where the number from B is lowe than C, the number from C will be higher than both A and B. So one of the possible combinations shown would be 1,5,10.

Kind regards