Forum Discussion
Generating Random Number, Excluding Cell in Next Calculation
Hello. I currently have a column of data that I need to select a random number from. I have the correct formula for that. The issue is that I need to exclude the cell that was "picked" in the pre...
This is probably jumping the gun somewhat because dynamic arrays are only just starting to be released to Office 365 users. DAs allow the same strategy of generating a set of random numbers and using their sort order that was used by IngeborgHawighorst to be applied directly to the list of values without the use of a helper range or index lookup.
= SORTBY( ValueList, RANDARRAY(COUNT(ValueList)) )