How to Draw Names in Excel – Spreadsheet Tools

Excel offers countless tools that can be easily run from your PC, one of which is creating drawings. With this option, you can create different groups for a different activity, either in a spreadsheet or from other tools discussed in the following information. Join us to discover how to create a drawing with Excel quickly and easily.

How to draw names in Excel – Spreadsheet Tools

Index( )

  1. How should you sort the data or names in your Excel tables?
  2. What Excel functions can you use to output random names?
    1. BETWEEN
    2. INDEX
    3. YEAH
  3. How can you do the draw in Excel with numerical data?

How should you sort the data or names in your Excel tables?

To run raffles within your spreadsheet, the data, whether by first or last name or by different groupings, must be sorted. This makes it much easier for the system to locate the potential winner from the list, or it takes longer to react, wasting valuable hours that could be spent on other tasks.

The way to do this is extremely easy, and you can sort by tables, cells, or individual rows and columns within a sheet. You can do this by selecting a cell (the one you want to sort) and going to the top of the page, clicking on sort and filter, or by clicking on sort by single file in the data box for a much faster process.

After this, select Sort from beginning to end, by cells, by selection, in random order, descending or ascending, or by order from A to Z (you can sort by numbers). This process can be repeated multiple times to keep it up to date. With Excel, you can also easily delete data from tables .

What Excel functions can you use to output random names?

This is an extremely easy process that any administrator or guest can perform within the Excel system, regardless of whether they are on a mobile device or a computer. Simply position yourself over a cell and press CTRL or F9 to randomly select a cell from the list within the spreadsheet.

From the functions executed by F9, the options are displayed, indicating which ones you want to select. You can select from 1 to 100 if that’s the total number added. Another way to randomly output names is to click on a cell and drag it to the end of the sheet, then list the names at random . This technique also works as a detector for duplicate names and other information.

There are other ways to perform this function, such as through tools built into the Excel system, such as those we’ll discuss below. With this platform, you can also quickly hide different cells within rows or columns using the keyboard.

RANDOM.BETWEEN

It is important that you know that to execute any function within the Excel program you must enter them in the following way =Random (in the box you write the function ) and then the numerical sequence that indicates up to where the check will be performed.

To use the RANDBETWEEN option, you need to select one of the cells in the sheet and type the execution in the text box; it should read: =RANDBETWEEN1, 100.   After completing this action, the system will display a random number from among those registered in the list. Click OK and the result will be ready. All of this is very simple. To repeat the process, click F9 again.

INDEX

The INDEX function works solely by returning previously assigned values ​​within a worksheet. This process is achieved by carefully identifying one of the rows that can be used for random name output. That is, it marks one of the many options displayed on the screen with a dark color, helping the user 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 and then add it to a draw. The process is carried out by selecting a box in the table and then clicking the F2 function or by typing =INDEX and Enter.

YEAH

This function is one of the most used in Excel, as it is easily accessible and very useful for all users. It works as a locator for different values ​​and can be obtained by locating them by name, address, format size, entry date, or by a longer time within the table in the list.

Among its main tools is the on-screen display of a true or false comparison message after selecting a cell. In these cases, it can be used to randomly output names or other data in a table. These functions are most beneficial for large companies with a large number of employees added to a spreadsheet. All of this contributes to greater organization.

How can you do the draw in Excel with numerical data?

One of the main advantages of using Excel is that you can perform different processes in many ways with just a few steps. Alternatively, you can use the same option but change the name. This is for performing a draw; changing the values ​​of functions like INDEX, IF, or BETWEEN to a sequence of numbers .

You do this with the established values; instead of adding one of the functions, you add the table numbers by row or column using the symbols (<>), the greater or lesser, which indicate the desired order of the draw. You can also do it in random order by clicking on the same option under All + Randomize all results.

There are many options available to run a drawing using Excel. The steps are simple, yet organized and very practical. You can also use other tools, such as number separation and customization options.

 

Leave a Comment

Scroll to Top