Combinations

[dinesh4you]

Dear sir,
I have some 3 digit numbers in increasing order like as 123, 124, 134, 125, 135, 145 and till 890 where zero is last digit. everyone is in increasing order.

Now i want to search how many combinations will be available from 1 to 8 counting or 1 to 7 counting whichever you can imagine but question is how many combinations of 3 increasing orders from 1 to 8.

 

[dinesh4you]

Well, firstly, those numbers aren't increasing. And your requirement doesn't make sense ... "1 to 8" means what exactly? Same with "3 increasing orders"? Explain clearly what you want, and give examples, maybe?

That explanation seems clearer, but I don't understand what that attachment is showing? It has all figures from 12345678890 and has 120 different output cells, and doesn't seem to be results from a particular combination set of calculations. So, what is that showing, exactly?

I've sent it your email ... by the way here is the same set using my formulas:

Mod note: email addresses removed
Your excel formula can smooth my living and professional life.

 

[GlennUK]

I sent it to the correct email id. I will also send to the alternative one.

 

[RoryA]

Please do not email solutions. Either use XL2BB to post a usable table here, or at least post the formulas in the thread.

 

[GlennUK]

The formulas are in thread, more than once, in the screen-shots.

 

[RoryA]

Yes, but pictures of formulas aren't particularly helpful.

 

[GlennUK]

In case anyone wants the text of the formulas:

Cell formula A2

=IF(ROW()>COMBIN($F$1,3),"",IF(B1=$F$1-1,A1+1,A1))

Cell formula B2

=IF(ROW()>COMBIN($F$1,3),"",IF(A1<>A2,A2+1,IF(C1=$F$1,B1+1,B1)))

Cell formula C2

=IF(ROW()>COMBIN($F$1,3),"",IF(OR(B1<>B2,A1<>A2),B2+1,C1+1))

Cell formula D2

=IFERROR(INDEX($G$1:$G$10,A2)&INDEX($G$1:$G$10,B2)&INDEX($G$1:$G$10,C2),"")