I have a inquiry of what i would like to perform using macros via excel. I want to create a self-generating data output of all the non-repeating permutations of a 20 object items ( i.e. digits ) ( example 1,42,46,47,) the sample of 4 digit numbers was gathered from the 20 object data set . { ,3,12,17,28,36,44,56,23,34,14,2,1,42,46,48,47,65,77,79,80 }
I try the comb in formula in excel yet i keep getting a value## error .
I ran across something to do with having to use VBA due to complex computations being as a such a high range of calculations ?
Please help me out if any way you can it would be most greatly appreciated !
- CrownstarT
Bookmarks