Microsoft Excel tutorial on randomly sorting a list.
Sort a list into random sequence.
Can Excel Randomly Sort Data?
Excel Create Random Order?
Excel Random Sort?
Can Excel Randomly Sort Data?
Excel How To Random Sort?
Excel Random Order?
Excel Random Order List?
Excel Random Row Order?
Excel Create Random Order?
Sort a list into random sequence.
Can Excel Randomly Sort Data?
Excel Create Random Order?
Excel Random Sort?
Can Excel Randomly Sort Data?
Excel How To Random Sort?
Excel Random Order?
Excel Random Order List?
Excel Random Row Order?
Excel Create Random Order?
Transcript of the video:
How can Excel randomly sort this list?
Three different ways! 1st way.
Count how many people. See there's 24.
Over here, =SORTBY(. Here's the list.
Comma. RANDARRAY of 24.
Close, Close. You're done.
Every time you press F9 - new version of the list. Option two: this is if you don't know how many people are there and it might be changing. So you ask for the COUNTA( of those items.
Close, Close, Close. Every time you press F9 you get a new list.
Option three. This is when you don't have SORTBY yet - you're in an old version of Excel. Add a new column with Rand.
=RAND(). Double click and copy that down. Every time that you now sort data A to Z, A-Z, A-Z, A-Z, A-Z you get a new ordering of the list. If you like this video, please, down below, Like, Subscribe, and Ring the Bell. Feel free to post any questions or comments down in the comments below.
Three different ways! 1st way.
Count how many people. See there's 24.
Over here, =SORTBY(. Here's the list.
Comma. RANDARRAY of 24.
Close, Close. You're done.
Every time you press F9 - new version of the list. Option two: this is if you don't know how many people are there and it might be changing. So you ask for the COUNTA( of those items.
Close, Close, Close. Every time you press F9 you get a new list.
Option three. This is when you don't have SORTBY yet - you're in an old version of Excel. Add a new column with Rand.
=RAND(). Double click and copy that down. Every time that you now sort data A to Z, A-Z, A-Z, A-Z, A-Z you get a new ordering of the list. If you like this video, please, down below, Like, Subscribe, and Ring the Bell. Feel free to post any questions or comments down in the comments below.
