Array Creation Build-out of all non-repeating 4,845 4 / 20 digit combination ?

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

Thank you it works yet I was kind of needing it to have All combinations in array yet without Repeats ?