permutations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a list of permutations for all 4 digits numbers using numerals 1-6.
How do I go about doing this?
 
In cell A1, type in the number 1111. This is your lowest number.
In cel A2, use the following formula.

=IF(A1=6666,"stop",IF(--RIGHT(A1,3)=666,A1+445,IF(--RIGHT(A1,2)=66,A1+45,IF(--RIGHT(A1,1)=6,A1+5,A1+1))))

copy/paste this formula downward. Should error out at row 1297.

double check it, but I think this is the list you are looking for.
 
Has been covered many times. Suggest a Google newsgroup search
 
Thank you Jonathan!! It worked. It went a bit further than 1297. It ended
at 1378. It is appreciated.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List number of permutations for text nums 20
Scramble a number 8
List of Permutations 1
List of Permutations when 2 letter is taken at a time 5
permutations of six digit number 4
Pls help noobie generate a whole buncha permutations 1
How to create a list of permutations and combinations? 2
PERMUTATION AND COMBINATION 3

Back
Top