{"id":6030,"date":"2017-03-07T15:22:35","date_gmt":"2017-03-07T14:22:35","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6030"},"modified":"2023-11-30T20:56:40","modified_gmt":"2023-11-30T19:56:40","slug":"create-a-random-list-ordering-with-excels-rand-formula","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-a-random-list-ordering-with-excels-rand-formula\/","title":{"rendered":"Create a Random List with Excel’s RAND Formula"},"content":{"rendered":"

What does it do?<\/strong><\/em><\/p>\n

Gives you a random number between 0 and 1<\/p>\n

Formula breakdown:<\/strong><\/em><\/p>\n

=RAND()<\/span><\/p>\n

What it means:<\/strong><\/em><\/p>\n

=RAND(Will automatically choose a random number between 0 and 1)<\/span><\/p>\n

\n

Excel is able to do a lot of things that most users are unaware of! \u00a0One thing that amazes me & I use almost daily is its ability to create random numbers for me!<\/p>\n

But why would I even need random numbers?<\/p>\n

Random numbers in Excel are great if you want to fill in a column with random values so you can create quick charts or just do any kind of random\u00a0Excel analysis.<\/p>\n

One of my best uses of the RAND function in Excel is to create random numbers for a raffle\u00a0draw!<\/p>\n

Thankfully this is very easy to do with Excel’s\u00a0RAND\u00a0<\/strong>formula!<\/strong><\/p>\n

I explain how you can do this below:<\/p>\n

\n