= Rand ()
Enter, drop-down fill formula
Then, select all data regions and sort them by column F.
You can choose.
Repeat the sorting and selection process.
How to generate numbers randomly in excel tables can use rand () function. Select a cell directly and enter =RAND () in the edit field.
How to Fill Random Numbers in excel Tables with rand Function
Operation method:
(1) generate a random number between a and b (a
In the first cell, enter: = rand () * (b-a)+a.
For example, generate a random number between 1 and 10. Input: =RAND()*9+ 1.
For the remaining numbers, place the mouse in the lower right corner of the grid and drag it down when it becomes a cross.
② generate a random integer between a and b (a
Enter: =INT(RAND()*(B-A)+A) in the first cell.
For example, generate a random integer between 1 and 10, and input: =INT(RAND()*9+ 1).
The rest, put the mouse in the lower right corner of the grid and drag it down when it becomes a cross.
For the remaining numbers, place the mouse in the lower right corner of the grid and drag it down when it becomes a cross.
③ generate a random number between a and b (A≤ random number ≤B)
Enter =INT(RAND()*(B-A+ 1))+A in the first cell.
For example, generate a random integer from 1 to 100. Input: = int (rand () *100)+1.
For the remaining numbers, place the mouse in the lower right corner of the grid and drag it down when it becomes a cross.
④ generate a random integer between a and b (A≤ random number ≤B)
Enter =RAND()*(B-A+ 1)+A in the first cell.
For example, generate a random integer from 1 to 100. Input: =RAND()* 100+ 1.
For the remaining numbers, place the mouse in the lower right corner of the grid and drag it down when it becomes a cross.
⑤ If it is version 2007 or version 20 10, generate a random integer between A and B (A≤ random number ≤B).
Enter: =RANDBETWEEN(A, b) in the first grid.
For example, generate a random integer between 1 and 10. Enter: = =RANDBETWEEN( 1+0, 10).
To get a random decimal, enter = =RANDBETWEEN( 1+0, 100)/ 10.
⑥ Others: above 2003 edition.
Enter: =RAND () in the first cell.
Get a random number greater than or equal to 0 and less than 1.
How to copy the data randomly extracted by rand function in excel table ~ ~! This function is variable. If you want to use some non-repetitive random numbers, you can copy the data obtained by rand (), then choose Paste Special (select values), and then use conditional format (or other methods such as sorting) to check whether there are duplicates.
How to randomly generate numbers between 20 ~ 150 in EXCEL tables =RAND()*( 150-20)+20 carriage return.
Then you can adjust the accuracy.
Rand ()
explain
To generate a random real number between a and b, use:
RAND()*(b-a)+a
If you want to generate a random number with the function RAND, and it does not change with the cell calculation, you can enter "=RAND ()" in the edit field, keep the editing status, and then press F9 to permanently change the formula to a random number.
example
It may be easier to understand if you copy the example into a blank worksheet.
operational approach
Create a blank workbook or worksheet.
Please select an example in the help topic. Do not select row or column headings.
Select an example from the help.
Press ctrl+C.
In the worksheet, select cell A 1, and then press ctrl+v.
To switch between viewing results and viewing formulas that return results, press Ctrl+ ` (accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.
A b
Formula Description (Result)
=RAND () A random number (variable) between 0 and 1.
=RAND()* 100 A random number (variable) greater than or equal to 0 but less than 100.
How to randomly select a non-repeating Excel table =RANDBETWEEN( 1, 10)
1 minimum quantity
10 maximum quantity
How to set one or more lines of window freezing in excel table 1? If one line in excel table is frozen, you can set it through the freezing window in the view. Select the rows to freeze, click View, and then select Freeze Split Window in the freeze window. 2. The specific operation is as follows. Select the downlink window to freeze, click View, select the freeze window, and then select the freeze split window.
Methods/steps
We want to freeze a line in the window, and the line will not move when the mouse scrolls down, but how can we achieve this effect? Let's take freezing the window in the third row as an example.
Select the fourth line with the mouse, and then click View → Freeze Pane → Freeze Split Pane in the menu bar.
In this way, the mouse scrolls down, and the cells above the black thick line are fixed. Simply put, click on the next row of cells that need to be frozen.
If we want to cancel this setting, we also click View in the menu bar, and then click Freeze Pane → Unfreeze Pane, so that the setting just now will be cancelled.
If we want to freeze some rows and columns of the window, how can we fix them when the mouse scrolls down? Let's take freezing the window in row 9 and column C as an example. Click the mouse to select cell D 10, and click View → Freeze Pane → Freeze Split Pane in the menu bar. In other words, click the intersection of the cells in the next row and column of the row and column that need to be frozen.
After freezing the window, the mouse scrolls down and the cell above the straight line indicated by the arrow is fixed.
Similarly, by dragging the scroll bar to the right, you can see that the windows on the left side of the straight line indicated by the arrow are all fixed.
eight
If we want to cancel these settings, we also click View in the menu bar, and then click Freeze Pane → Unfreeze Pane, so the settings just now will be cancelled.
nine