how to randomly select data in excel
Thanks JE this formula works.
"JE McGimpsey" wrote:
Did you have 4 cells selected when you array-entered the formula?
In article ,
Mandeep Dhami wrote:
I tried this formula [Worksheet Method 2: Using SMALL() with a helper column
] but I just got only 1 random number in column C1........where as I was
expecting 4 random numbers to be displayed in column C1:C4
|