Hi - I would like to generate all the 5 digit long permutations that can be constructed from a pool of 30 unique digits.
The pool of 30 digits are: 2, 3, 4, 6, 7, 8, 9, A, B, C, D, E, F, G, H, J, K, L, M, N, P, Q, R, T, U, V, W, X, Y, Z.
[O, 0, 5, S, I, 1] are excluded due to the likelihood of a manual recording error, i.e. confusing O for 0 etc.
An example of a result would be: A27BK
I calculate that there should be 17,100,720 different permutations. Is excel able to handle that size of calculation? (I have excel 2016)![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
The pool of 30 digits are: 2, 3, 4, 6, 7, 8, 9, A, B, C, D, E, F, G, H, J, K, L, M, N, P, Q, R, T, U, V, W, X, Y, Z.
[O, 0, 5, S, I, 1] are excluded due to the likelihood of a manual recording error, i.e. confusing O for 0 etc.
An example of a result would be: A27BK
I calculate that there should be 17,100,720 different permutations. Is excel able to handle that size of calculation? (I have excel 2016)