asked on # 4n tri to convert 0 number

4n tri convert 0 number

example number

8074

807 480 487 407 235 359 239 259 283 203 237 835 035 357 285 205 257 435 835 035 459 859 059 439 839 039 243 283 237 439 839 379 249 289 279 245 205 257 249 209 279 207 459 059 579

then show up

29094987_4n_tri_0_to.xlsm

example number

8074

807 480 487 407 235 359 239 259 283 203 237 835 035 357 285 205 257 435 835 035 459 859 059 439 839 039 243 283 237 439 839 379 249 289 279 245 205 257 249 209 279 207 459 059 579

then show up

29094987_4n_tri_0_to.xlsm

Microsoft ExcelMicrosoft Office

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

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

Martin

Is an great job

Thanks

yes please !

in the example i show 45 tri numbers

you need that workbook?

also i would like to ask for an improve?

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...

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?

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...

- Add 5 to the 1st digit of each of them which gives another 24 numbers
- Add 5 to the 2st digit of each of them which gives another 24 numbers
- Add 5 to the 3st digit of each of them which gives another 24 numbers
- Add 5 to all 3 digits of each of them which gives another 24 numbers
- Repeat each of the digits in 8074 three times which gives another 4 numbers
- Add 5 to each of the digits in those four numbers which gives another 4 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

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

Martin

Im a greed with you

then need work with any number with 0

now is working only with number 8809

Best Expert !

Im a greed with you

then need work with any number with 0

now is working only with number 8809

Best Expert !

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

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

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

Tri can be improve with the ORD LAW

You didn’t ask for that.

Martin

tri is working

but can be improve to ORD

tri is working

but can be improve to ORD

can be ??

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

Great Job Best expert !

Learn Excel in Tamil

Thnks for the fast response

you are welcome

is not the same situation

Thnks for the fast response

you are welcome

is not the same situation