4n tri to convert 0 number

Hi Is this duplicate request ?

I'm concerned about the 487 you show in the expected results. in the previous question where you requested 2-digit pairs I initially split a number like 4807 into 3 pairs, those pairs being 48, 40 and 47, which are all left to right. 78, 84, etcetera were not considered because they were not left to right. Should I have included them?

In any case this is the results I get for 3n when I only consider right to left 3-digit combinations.
29095047.xlsm

Martin  

Is an great job
Thanks

Should I have included them?

yes please !

in the example i show 45  tri numbers

you need that  workbook?

also i would like to ask for an improve?

I could be wrong about this, or I could be misunderstanding your requirements, but I think there are a lot more than 45 numbers.

To begin with there are 24 permutations of a 4-digit number taken 3 at a time. Using 8074 as an example, the permutations of sets of 3 are:

807, 804, 870, 874, 840, 847, 087, 084, 078, 074, 048, 047, 780, 784, 708, 704, 748, 740, 480, 487, 408, 407, 478, 470

Then after that I believe your requirements are  to...

1. Add 5 to the 1st digit of each of them which gives another 24 numbers
2. Add 5 to the 2st digit of each of them which gives another 24 numbers
3. Add 5 to the 3st digit of each of them which gives another 24 numbers
4. Add 5 to all 3 digits of each of them which gives another 24 numbers
5. Repeat each of the digits in 8074 three times which gives another 4 numbers
6. Add 5 to each of the digits in those four numbers which gives another 4 numbers

Which gives you a total of 24 * 5 + 4 + 4 = 128 numbers!

As I said above, I could be wrong, but if I'm right can you really get any useful information when you look at the 128 results for each number?

I went ahead and did some work on the tri numbers. In the attached workbook if you click the 'Convert 0 Numbers 3n' button you will see results for only row 20. I did that so we can more easily discuss the results.

The green cells are the permutations of 8809. There are 12 of them. In my previous post I said there should be 24, but because '8'appears twice in the number there are only 12 unique ones.

The yellow cells are the result of adding 5 to the 1st digit of each of them.

The light blue cells are the result of adding 5 to the 2nd digit of each of them.

The pink cells are the result of adding 5 to the 3rd digit of each of them.

The gray cells are the result of adding 5 to all three digits of each of them.

The salmon-colored cells are the result of repeating each digit in 8809 three times.

The dark blue cells are the result of adding 5 to each digit in the salmon-colored cells.

Before I do anything else I need you to tell me if that's what you want, keeping in mind that for a value like 4805 there will be almost twice that many results.
29095047a.xlsm

Martin

Im a greed with you

then  need work with any number with 0

now is working only with number 8809

Best Expert !

Martin  

 i know the tri is  more dificult  excuse me  because  i get lost with a lot of work around   but  i try to be proper as i can

Is tri working correctly?

Martin

Tri can be improve with the ORD LAW

You didn’t ask for that.

Martin

tri is working

but can be improve to ORD

can be ??

Great Job Best expert !

Learn Excel in Tamil
Thnks for the fast response

you are welcome

is not the same situation