{"id":29696,"date":"2023-07-05T21:21:18","date_gmt":"2023-07-05T19:21:18","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=29696"},"modified":"2024-04-19T19:15:13","modified_gmt":"2024-04-19T17:15:13","slug":"quick-ways-to-generate-random-numbers","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/quick-ways-to-generate-random-numbers\/","title":{"rendered":"Generate Random Numbers: 2 Quick and Practical Ways in Excel"},"content":{"rendered":"

\"Generate<\/a><\/em><\/p>\n

Let’s say you are in charge of a task to create a system where you have to randomly select customers for a special promotion in your small business. You want to ensure fairness and equal opportunity, giving every customer a chance to participate. But how do you go about selecting customers randomly?<\/p>\n

Excel can make the selection process for the promotion unbiased and efficient. In this article, we will explore the methods that will allow you to Generate Random Numbers easily:<\/p>\n

Let’s look at these methods thoroughly!<\/p>\n

Download the Excel Workbook below to follow along and understand How to Use Substrings in Microsoft Excel<\/a>\u00a0<\/strong><\/p>\n

download excel workbook<\/strong><\/span>Random-Numbers.xlsx<\/span><\/a><\/h4>\n

 <\/p>\n

RAND Function: Generating Random Numbers Between 0 and 1<\/span><\/strong><\/p>\n

We want to randomly select customers from your customer database.<\/p>\n

Open an Excel worksheet and create a column labeled Order of Winners<\/strong> in column A<\/strong>, Customer Names<\/strong> in column B<\/strong>, and Random Number<\/strong> in column C<\/strong>. In cell C2<\/strong>, enter the formula<\/a> =RAND()<\/strong>. This formula generates a random number<\/a> between 0 and 1<\/strong>.
\n\"Generate<\/a><\/p>\n

Press ENTER<\/strong>. Drag the formula down<\/strong> to the rest of the rows.
\n\"Generate<\/a><\/p>\n

\"Generate<\/a><\/p>\n

Select<\/strong> the cells with the random numbers and Right-click<\/strong> to Copy<\/strong>.
\n\"Generate<\/a><\/p>\n

Select cells A2 to A31<\/strong> and Right-click<\/strong>. Go to Paste Special<\/strong>, then Values<\/strong>.<\/p>\n

Note: This step is important because RAND and RANDBETWEEN are volatile formulas<\/a> and would recalculate every time there is any change in the worksheet.<\/i>
\n\"Generate<\/a>
\n\"Generate<\/a><\/p>\n

Delete C2 to C31<\/strong> since RAND will keep generating random numbers. Select A2 to B31<\/strong> and Right-click<\/strong>. Go to Sort<\/strong> and you can choose between Sort Largest to Smallest<\/strong> or Sort Smallest to Largest<\/strong>.
\n\"Generate<\/a><\/p>\n

Select the desired number of customers from the sorted list based on the random numbers assigned to them. For example, if you want to select 10 customers, choose the top 10 customers from the sorted list.
\n\"Generate<\/a><\/p>\n

Note: Given the small range (1 to 30) that we are working with, it is possible that duplicate numbers may be generated. However, we can rely on Excel to hand<\/a>le the sorting process and resolve any duplicate values appropriately.<\/em><\/p>\n

RANDBETWEEN Function: Generating Random Whole Numbers in a Custom Range <\/span><\/strong><\/p>\n

What if we want to know how to generate random whole numbers<\/a> within a chosen range in Excel?<\/p>\n

Open an Excel worksheet and create a column labeled Order of Winners<\/strong> in column A<\/strong>, Customer Names<\/strong> in column B<\/strong>, and Random Number<\/strong> in column C<\/strong>. In cell C2<\/strong>, enter the formula =RANDBETWEEN(1,30)<\/strong>. This formula generates a random number<\/a> between 1 and 30<\/strong>.
\n\"Generate<\/a><\/p>\n

Drag down the formula in cell C2<\/strong> and paste it into cells C3 to C31<\/strong> to generate random whole numbers for each customer.
\n\"Generate<\/a><\/p>\n

Select C2 to C31<\/strong> and Right-click<\/strong>. Select Copy<\/strong>.
\n\"Generate<\/a><\/p>\n

Select cells A2 to A31 and Right-click<\/strong>. Go to Paste Special<\/strong>, then Values<\/strong>.
\n\"Generate<\/a><\/p>\n

Delete C2 to C31<\/strong> since RANDBETWEEN will keep generating random numbers.
\n\"Generate<\/a><\/p>\n

Select A2 to B31 and Right-click<\/strong>. Go to Sort<\/strong> and you can choose between Sort Largest to Smallest or Sort Smallest to Largest<\/strong>.
\n\"Generate<\/a><\/p>\n

Select the desired number of customers from the sorted list based on the random numbers assigned to them. For example, if you want to select 10 customers, choose the top 10 customers from the sorted list.
\n\"Generate<\/a><\/p>\n

There you have it! Excel’s RAND and RANDBETWEEN functions are indispensable tools for small businesses aiming to randomly select customers for special promotions. By understanding how to leverage these functions effectively, you can implement a fair and unbiased customer selection process, boosting engagement and maximizing the success of your promotions. With these methods, you can be assured that you\u2019re promotion will be fair and square. Now, go ahead and apply this to your tasks!<\/p>\n

If you want to generate a list of random numbers in an array, click here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Let’s say you are in charge of a task to create a system where you have to randomly select customers for a special promotion in your small business. You want to ensure fairness and equal opportunity, giving every customer a chance to participate. But how do you go about selecting customers randomly? Excel can make […]<\/p>\n","protected":false},"author":1,"featured_media":29697,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Generate Random Numbers: 2 Quick and Practical Ways in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[288,293,20],"tags":[1214,236,149,90,62],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/29696"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=29696"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/29696\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/29697"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=29696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=29696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=29696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}