Forum Discussion

GPratik's avatar
GPratik
Copper Contributor
Feb 15, 2020
Solved

How can I enlist permutations of an 8 digit number containing only 1, 2 & 3

I want to create a List of 8 digit numbers which contains only 1, 2 & 3 in it

excel
Macros and VBA
  • Savia's avatar
    Savia
    Feb 15, 2020
    In A1, type =BASE(ROW()-1,3,8). Copy that down to A6561. Then next to that type =SUBSTITUTE(A1,"0","3") and copy down.

1 Reply

  • Savia's avatar
    Savia
    Iron Contributor
    Feb 15, 2020
    In A1, type =BASE(ROW()-1,3,8). Copy that down to A6561. Then next to that type =SUBSTITUTE(A1,"0","3") and copy down.

Resources