Combinations from 4 lists with conditions

Hi,

I have 4 identical lists(A, B, C, D), each containing the following numbers:

5
10
15
22
44
50
65
97
132
200

I want to make combination lists with the following conditions:

Using only A & B
Condition: A < B

Using A, B & C
Condition: A < B < C

Using A, B, C & D
Condition: A < B < C < D

urgent help will be highly appreciated....

For example, ...?

Originally Posted by shg

For example, ...?

Attaching excel file for illustration...

I have 4 identical lists(A, B, C, D), each containing the following numbers:

5
10
15
22
44
50
65
97
132
200

I want to make combination lists with the following conditions:

Using only A & B
Condition: A < B

Using A, B & C
Condition: A < B < C

Using A, B, C & D
Condition: "A < B" and "C < D"

urgent help will be highly appreciated....

I can somewhat follow the logic of the formulas in cells P2:X2 but I don't understand why the formula in Y2 isn't: =IF($C7>D7,1,-1)
Perhaps if we could understand the logic we could attempt to write formulas or code that would do what you want.

Originally Posted by JeteMc

I can somewhat follow the logic of the formulas in cells P2:X2 but I don't understand why the formula in Y2 isn't: =IF($C7>D7,1,-1)
Perhaps if we could understand the logic we could attempt to write formulas or code that would do what you want.

Apologies for delayed reply....

You are right... it was my mistake... I forgot to change $B to $C

Y2 should have been =IF($C7>D7,1,-1)

Pls help....

Here is a possibility for the A<B formula that starts in cell P2 of the file attached to post #3:

Formula:

Please Login or Register  to view this content.

I'll attempt to post a possibility for A<B<C later if someone else hasn't already done so.
Let us know if you have any questions.

I found helper rows defining 5 with 10, 5 with 15, 5 with 22, etc. simpler.

In the attached find this for the A B line in P4 and filled across.

Formula:

Please Login or Register  to view this content.

Then for the A B C line in P10 and filled across.

Formula:

Please Login or Register  to view this content.