Forum Discussion
Nicola Flowers
May 09, 2018Copper Contributor
A-Z excel
I have a list of names in A-Z order. But I want them in a random order so that they are mixed up.
Haytham Amairah
May 09, 2018Silver Contributor
Hi Nicola,
You can customize the sort order as you want, here are some suggested random orders that you can use:
G, T, N, K, S, U, W, P, D, K, N, G, V, K, Y, B, P, F, X, F, L, T, O, F, P, S
H, A, N, I, Y, C, R, F, N, A, D, D, B, N, J, K, Z, W, I, V, A, F, Y, A, E, D
P, L, V, T, D, D, G, F, K, U, D, U, V, W, L, O, I, R, W, D, Q, A, V, H, F, V
Please create a custom list from one of the above orders.
To figure out how to create a custom sort list, please read this https://support.office.com/en-us/article/sort-data-using-a-custom-list-def8ff2b-681a-4fc3-9bd2-a06455c379e1.
Hope that helps
Haytham