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.

 

[GlennUK]

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?

 

[dinesh4you]

I have a unique 3 digit series. Image is large so it is not uploading. All the 3 digit combinations are 1 to 0.
Example is 123, 124, 125......
789, 780, 890.
Now i am writing 1234567890. Now i want to know how many combinations are available in 124578(between 6 digit out of 10).
First 3 digit of combination in 124568 is 124 and last is 578. I think you are getting my question right now?

 

[dinesh4you]

I am able to upload screenshot. Please see all the combination from figure 1 to 0. But my question is that....
How many combinations in figure of 124578 or 235790 or 2479. If i want to know manually then i will write on a paper for combination of 2479 from this list. But i need any formula or any trick.

 

[GlennUK]

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?

 

[dinesh4you]

You got my point. These are 3 digit combinations from 1 to 0. But i need any special figure combination. For example if i want the combination of 3680 then answer will be 368, 380, 360 and 680. All are covered in 3680 figure. Now you understand? Now please provide me the combinations of 2458.

I need any formula or trick to find the combinations from 2458. Answer must be 245, 248, 258 and 458

 

[GlennUK]

Have a look at this:

 

[dinesh4you]

Respected sir, can you please share this spreadsheet on my mail id [email removed]
I am so much thankful for it. Same question i asked to open chat gpt. That gives all correct answers.

 

[GlennUK]

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

 

[dinesh4you]

Thank you so much sir. This sheet will be useful on daily basis in my profession.