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 without repeating
thanks
1 Reply
Sort By
Does this do what you want?
=SORTBY(A1:A10, RANDARRAY(10))