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?