In this article we will learn how to pick the name randomly from a list, so we will use the INDEX formula along with the ROUND, RAND and COUNTA formulae in Microsoft Excel 2010. We use these functions for Quiz, Games and Lottery etc, where there is no criteria defined for the selection.
Let’s take an example to understand how to select random names from a list in excel:-
Example: We need random number selection i.e. one of the values from the list in column A which contains a list of Serial Nos.
Follow the below mentioned steps:-
This is all about that how you can select the random number from a list now we will do a simple exercise to select random text from a list.
We have data in range A1:B7, in which column A contains serial numbers and column B contains the student name. This data belongs to a school, where the application was submitted foradmission. The school is having only 3 seats, while the applicatns are 6. The school’s management wants to select the students randomly without being partial.
To randomly select the student name from the list, follow the below given steps:-
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.