= Rand ()
Pull-down filling
Then enter the formula anywhere:
=INDEX(A$ 1:A$ 100，MATCH(SMALL(B$ 1:B$ 100，ROW(A 1))，B $ 1:B $ 100，))
Drop-down padding 19 line
A 1:A 100 is the area where data is randomly selected.
B 1:B 100 is the data area generated by the RAND () function.
Ask an expert: How to randomly select a column of data in Excel? Your question is not clearly described. If you want to randomly select the value of a cell in a column (such as column A), you can use the following formula (assuming the result is placed in B 1):
=CELL("contents "，OFFSET(A 1，ROUND(RAND()* 10，0)，0， 1， 1))
Round (rand () * 10,0) can generate a random integer from 0 to10 as a random line number.
If the data exceeds 10, change 10 to the value you want (for example, 100).
How to manipulate a column of data in Excel to supplement the numbers in the original cell?
Select the cell or cell range where these values are located, right-click, set the cell format, customize, write 000000 in Type, and confirm.
So writing 1 in the cell will get 0000 1.
Method 2
Use a formula to realize in another cell.
Assuming that the data is written in column A, starting from cell A 1, the formula can be written in cell B 1.
=IF(A 1= ""，" "，TEXT(A 1，" 000000 "))
Drop-down filling formula
How to get a new column of data from a column of data in EXCEL? Suppose you have a column of data in column A, and you want to generate 2 times as much data in column B as in column A, you can enter it in B 1
=2*A 1
Copy it when you get in the car.
This is the simplest.
I can only say so much because you didn't give specific conditions.
How to randomly disrupt a column of data in excel? Look at the raw data first.
Double-click the E2 cell and enter the function:
= Rand ()
After carriage return, the cell will return a random number less than 1 and greater than 0.
The RAND () function is a function that returns a random number with no parameters, and the return value is between 0 and 1. Generally speaking, the results returned by executing the RAND () function in multiple cells of the worksheet at the same time will not be repeated.
Double-click the fill handle in the lower right corner of the cell to fill the function into the column to be selected.
Copy the data in the selected row, choose Paste Special from the right mouse button menu, and then select the number and number format.
After pasting, the return value of the RAND () function of the selected column will be converted into a numerical value.
Note: You can sort directly without pasting values.
Select all data columns, and then select Data-Sort.
Select the selected column as the primary key in ascending or descending order, and then click OK.
How does Excel randomly select some data from a column of data? Please take a screenshot to explain the conditions and requirements.
Suppose the data is in column A, you need to randomly get a row of data in column B, and then enter it.
=INDEX(A:A，RANDBETWEEN( 1:20))
How to find the sum of a column of data in excel? Demand formula. Use the SUM () formula, SUM(number 1, number2, ...)
The number 1, the number 2, ... is 1 to 30 parameters that need to be summed.
A
material
-5
15
30
five
real
Formula Description (Result)
= sum (3,2) plus 3 and 2 (5)
=SUM("5 ",15, TRUE) Add 5, 15 and 1, because literal values are converted into numbers, and logical values of TRUE are converted into numbers 1 (2 1).
=SUM(A2:A4) Add the first three numbers in this column (40).
=SUM(A2:A4, 15) Add the sum of the first three numbers in this column to 15 (55).
=SUM(A5, A6, 2) adds the sum of the values in the last two lines above to 2. Because values that refer to non-numeric values will not be converted, the value (2) in the above column will be ignored.
How to use formulas to make excel automatically select a column of data? Generally speaking, the OFFSET function is used to locate the data area. I don't know the specific situation and can't answer.
Upload a screenshot of the table with column numbers and data examples, clearly explain the known conditions, and what kind of results can be achieved in order to give you an accurate answer.
Ask excel experts how to edit formulas or functions in tables. As the date increases, you can push a column of data to the right in turn to find seven columns of data, and use the offset () function:
Assuming the date is A 10, enter the formula:
=SUM(OFFSET(A 1，0，A 10- 1):OFFSET(d 1，0，a 10- 1))
When A 10= 1, the result is sum(A 1:D 1).
When A 10=2, the result is sum(B 1:E 1).
....
How to query the same item in a column of data through excel formula? Take the question as the content (the subject of the email must contain "excel" so that I can distinguish non-spam email on this basis to avoid deleting it by mistake). See yqch 134@ 163 for the excel sample table file (showing the current situation and target effect) sent as an attachment.