Nov 02 2022 07:13 PM
Hi,
Is it possible in Excel to have a list of names, then assign to each name a unique random number, then sort the names based on there unique random number from (small to large)? I tried Randarray but did not work.
I then want to break this list down into groups on another sheet based on that sorting, in numerical order without having to copy and paste. i.e. numbers 1-5 would be one group, 6-10 would be another, and so on.
Thanks
Tim
Nov 02 2022 08:23 PM