# permutations

1. ## permutations

I need a list of permutations for all 4 digits numbers using numerals 1-6.
How do I go about doing this?

2. ## RE: 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. ## RE: 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?

4. ## Re: permutations

Has been covered many times. Suggest a Google newsgroup search
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"newyorkjoy" <newyorkjoy@discussions.microsoft.com> wrote in message
news:9ACD3893-B6FD-41B6-AB13-EE19F718E383@microsoft.com...
>I need a list of permutations for all 4 digits numbers using numerals 1-6.
> How do I go about doing this?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1