Forum Discussion
josepnikon
May 22, 2025Copper Contributor
excel function (help)
i would like to ask for some help with my excel so for example, i have a data of 1 to 10 1 2 3 4 5 6 7 8 9 10 in second column i want it to give a random number basing from the first column wi...
HansVogelaar
May 22, 2025MVP
Does this do what you want?
=SORTBY(A1:A10, RANDARRAY(10))