#lottery #excel #index #random
▬▬▬▬▬▬▬▬▬ஜ۩۞۩ஜ▬▬▬▬▬▬▬▬
▓▓▓▒▒░░ Open This Description ░░▒▒▓▓▓
▬▬▬▬▬▬▬▬▬ஜ۩۞۩ஜ▬▬▬▬▬▬▬▬
random name in excel
This Video how to randomly select a winner in excel. Assume you have thousands of customer information with unique order IDs. Your company has decided to randomly select a customer each week and give a special discount offer. If you are wondering how to do that then you can follow the article. We will discuss 2 very simple methods to select a random winner in excel. Hopefully, this will be helpful for you.

Download excel file for Practice
https://www.exceldemy.com/wp-content/...

1. Select a Random Winner Using Formula
First off, we will see the use of INDEX, RANDBETWEEN, and ROWS functions combined in a formula to choose a random winner. Follow just the steps below.

2. Use RAND Function to Select a Winner Randomly

How Does the Formula Work?

➤ ROWS(B5:E14)
The ROWS function returns the number of rows in a reference or array.
Output: 10

➤ RANDBETWEEN(1,10)
The RANDBETWEEN function returns a random number between two specified numbers.
Output: 7

➤ INDEX(B5:E14,7,1)
The INDEX function returns the value or reference of the cell at the intersection of a particular row and column, in a given range.
Output: “RD22A007”

Picking a winner at random on Excel




Ignore Tags:-----------
pick a winner from an excel list
excel random draw from list
how do you pick a winner with multiple entries
raffle generator multiple entries excel
how to do a random name drawing in excel
random name generator excel no repeats
how to randomly select a winner
excel random text generator from list



ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ

अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।

आप हमारे चैनल को Subscribe करे।
   / @comtutor  

फेसबुक पर पसंद करने के लिए क्लिक करें
  / comtutor4u  

ट्विटर पर फॉलो करने के लिए क्लिक करे
  / comtutor4u