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
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
Okay, this does all the rows for 3n. If this is correct then please ask a new question so that I can correct 2n.
29095047b.xlsm
1
 
LET (Learn Excel in Tamil)Reporting Automation ExpertCommented:
Hi Is this duplicate request ?
0
 
Martin LissOlder than dirtCommented:
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
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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?
0
 
Martin LissOlder than dirtCommented:
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?
0
 
Martin LissOlder than dirtCommented:
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
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Im a greed with you

then  need work with any number with 0

now is working only with number 8809

Best Expert !
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
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
0
 
Martin LissOlder than dirtCommented:
Is tri working correctly?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Tri can be improve with the ORD LAW
0
 
Martin LissOlder than dirtCommented:
You didn’t ask for that.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

tri is working

but can be improve to ORD
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
can be ??
0
 
Martin LissConnect With a Mentor Older than dirtCommented:
Since the code is doing what you asked for, please close it and ask a new question.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Job Best expert !
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Learn Excel in Tamil
Thnks for the fast response

you are welcome

is not the same situation
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.