Hi,
Im trying to generate a 5 row array of random combinations of numbers from a defined set. I want the array to change at will from lets say 5x10 to 5x30. Ive tried to use some of Myra's vba code but it will not work. For example column a will have the following numbers 5,12,37,45,89 etc and I want to paste an array formula in a matrix and have it spit out random combinations of those numbers. Please help
Thanks,
Im trying to generate a 5 row array of random combinations of numbers from a defined set. I want the array to change at will from lets say 5x10 to 5x30. Ive tried to use some of Myra's vba code but it will not work. For example column a will have the following numbers 5,12,37,45,89 etc and I want to paste an array formula in a matrix and have it spit out random combinations of those numbers. Please help
Thanks,