|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 1st, 2005, 04:18 PM
|
|||
|
|||
permutations
I need a list of permutations for all 4 digits numbers using numerals 1-6.
How do I go about doing this? 
|
|
#2
November 1st, 2005, 06:25 PM
|
|||
|
|||
|
permutations
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. "newyorkjoy" wrote: I need a list of permutations for all 4 digits numbers using numerals 1-6. How do I go about doing this?
|
|
#3
November 1st, 2005, 06:26 PM
|
|||
|
|||
|
permutations
Has been covered many times. Suggest a Google newsgroup search
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "newyorkjoy" wrote in message ... I need a list of permutations for all 4 digits numbers using numerals 1-6. How do I go about doing this?
|
|
#4
November 1st, 2005, 08:20 PM
|
|||
|
|||
|
permutations
Thank you Jonathan!! It worked. It went a bit further than 1297. It ended
at 1378. It is appreciated. "Jonathan Cooper" wrote: 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. "newyorkjoy" wrote: I need a list of permutations for all 4 digits numbers using numerals 1-6. How do I go about doing this?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Permutations | RedChequer | Worksheet Functions | 9 | September 26th, 2005 03:14 AM |
| Permutations | RedChequer | Worksheet Functions | 2 | September 25th, 2005 04:05 AM |
| calculate permutations of nonnumeric data | RonG | Worksheet Functions | 1 | March 31st, 2005 04:30 AM |
| Permutations | MR | General Discussion | 2 | July 28th, 2004 01:39 AM |
| are permutations possible? | Seth Hunter | Worksheet Functions | 1 | January 20th, 2004 12:09 AM |
Linear Mode
