Excel offers countless utilities that can be easily executed from the PC, one of them is the realization of raffles. With this option you can create different groups for a different activity carried out on a Sheet, or else; from other tools that are discussed in the following information. Join us to discover how make a draw with Excel quickly and easily.
How should you order the data or names in your Excel tables?
To carry out draws within your Calculations sheet, the data, either by names or surnames or different groups, must be ordered. This is to make it much easier for the system to locate from the list the possible winner or late in reacting, thus causing us to lose valuable hours that can be done in other things.
The way to do it is extremely easy and your order can go from the tables, cells or the different rows and columns within a sheet. You can do it by selecting a cell (the one that will be ordered) and going to the beginning, pressing on order and filter, or in order only File in the data box to make it much faster.
After this mark on Sort from start to finish, by cells, by selection, in random order, descending o Ascending, or in order from A to Z (They can be ordered by numbers). This process can be done multiple times to keep up to date. With Excel you can also easily delete data from tables.
What Excel functions can you use to randomize names?
This is an extremely easy process that can be run by any administrator or guest within the Excel system. Regardless of mobile or computer style device. You will only have to position yourself on a cell and run with CTRL or F9 keys to randomly select one from the list within the spreadsheet.
From the functions that F9 executes, the options are shown from which you want to select, they can be marked from 1 to 100 if it is the amount added. Another way to randomize names is by clicking on a cell box and drag it to the end of the sheet and list the names Randomly. This technique also works as a detector of names and other duplicate information.
There are other means by which this function can be performed and it is using tools that are built into the Excel system as they are that we will talk about next. With this platform you could also hide different cells between the rows or columns using the keyboard quickly.
RANDOM.BETWEEN
It is important that you know that to execute any function within the Excel program you must enter them as follows form =Random (inside the box you write the function) and then the numerical sequence that indicates up to where the verification will be carried out.
To use the RANDOM BETWEEN alternative you have to select one of the cells of the sheet, inside the text box you write the execution; would be: =RANDOM.BETWEEN1, 100. After having carried out this action, the system will show a random number among those registered in the list. Click OK and the result will be ready. All this in a very simple way. And to repeat the process click again on F9.
INDEX
The INDEX function works only returning previously assigned values within a worksheet. This process is achieved by detailed identification of one of the rows that can be used for a random output of names. That is, it marks one of the many options that are displayed on the screen with a dark color. Helping the user to more quickly identify another.
It can also be used to search for a value within a cell. In both cases it can be run to find a name to then add to a draw. The process is carried out by selecting a box in the table and then clicking on function F2 or typing =INDEX and Enter.
YES
This function is one of the most used in the Excel system, since it is easily accessible and very useful for all users. Works as a locator of different values and can be obtained by locating by name, address, format size, entry date, or longer within the table in the list.
Among its main tools is the display on the screen after selecting the True or False comparison message on a cell. In these cases it can be used for random output of names or through other data in a table. these functions have a higher profit in large companies with a large number of workers added to a spreadsheet. All this for a greater organization.
How can you make the draw in Excel with numerical data?
One of the main advantages of using the Excel program is that you can carry out different processes in many ways with just a couple of steps. Or failing that, using the same option but varying with the name change. This to carry out a raffle; to change values ​​of functions such as INDEX, IF, or BETWEEN to a sequence of numbers.
You do this in the values ​​that are established, instead of placing one of the functions you add the numbers of the table by rows or columns using the signs (<>) the greater or less than indicate how far you want to make the draw. It can also be in random order by clicking on the same option in All + Random all results.
There are many options that can be used to make a giveaway using Excel. With a simple step by step but in an orderly and very practical way. You can also use other tools such as number separation with customization options.
