In the daily office, because some companies need to get parties, sometimes they want to make random tools, which can be made by using our common office software excel, so let's introduce you to the method of making random tools with excel. Excel Tips
Methodological steps
1. Randomly generate a single piece of content
1. Open Excel**, and enter all the content involved in the generation first, such asRandom numbers need to be generated, enter the formula: in the cell where you want to display the result=randbetween(1,6), and thenPress the [Enter] key。So longPress the [F9] key to refresh to generate a random number
randbetween function] meansA random number is generated between two numbers
1, 6)] refers toThe beginning and end numbers of the list
2. IfThe content of the list needs to be randomly generated, then enter the function formula in the cell that displays the generated result:=index($b$2:$b$7,randbetween(1,6)), and thenPress the [Enter] key。That's itJust press the [F9] key to refresh and a random content will be generated
index function is used to find data and find the contents of a cell according to the specified rows and columns
b$2:$b$7] refers to the participating list cell range b2:b7Press F4 once to lockRanks;
randbetween(1,6)] is the function formula for step 1.
2. Randomly generate multiple contents.
1. Open Excel**, enter all the content in ** first, and create an auxiliary column in the blank space next to it, and enter the formula:=rand(), press Enter, and then move the mouse to the lower-right corner of the function cellWhen the cursor changes to a black + sign, drag down to fill to get the auxiliary column data.
Note: [rand() function] refers to a function between 0 and 1 that is randomly generated and not repeated.
2. If necessaryMultiple numbers are randomly generated, enter the formula: in the cell where you want to display the result=rank(c2,$c$2:$c$7), and thenPress the [Enter] keyCan.
rank function refers to the ranking of a certain number in a certain region
c2] refers to the first data cell of the auxiliary column
c$2:$c$7] refers to all data regions c2:c7,Press F4 once to lock
3. Move the mouse to the lower right corner of the cell where the formula is enteredWhen the cursor changes to a black + signand drag down to the number of items you want to draw, so you only need toPress the [F9] key to refresh to randomly generate multiple distinct numbers
4. IfMultiple list contents need to be randomly generated, then enter the function formula in the cell that displays the lottery result:=index($b$2:$b$7,rank(c2,$c$2:$c$7)), and thenPress the [Enter] keyand drag down to fill to the number you want to select. That's itAs long as you press the [F9] key to refresh, you can randomly generate multiple non-duplicate ** content
b$2:$b$7] refers to the participating list cell range b2:b7Press F4 once to lock the rows and columns