Lottery digital printing

1. If the data is in the A:D column of Sheet2, two auxiliary columns are inserted before the A column of Sheet2. 2. In the name box in the upper left corner, enter A2:A953, press enter, select cell A2:A953, press enter =RAND (), press Ctrl+Enter to end, and quickly enter a random number in cell A2:A953 (random number repetition probability is extremely low); 3. Enter the following formula in cell B2, and then fill in the formula downwards, and get the sort of data in column A (also non-repetitive sort) =RANK(A2, A:A)4. Enter the following formula in cell A2 of Sheet 1, and then fill in the formula in cell D36 1 downwards, and it is obtained that the corresponding line in column $B:$F Sheet2 is completely matched with the current line number, and the number is returned. 5. When fetching data at random, as long as one data is input in the worksheet, a set of data will be retrieved in "automatic calculation". Therefore, column A of Sheet2 can be used as "value" for "copy" and "paste selectively" to avoid continuous data conversion. Or set the calculation option in the formula options to manual. 6. Note: When the random function is obtained through the RANDBETWEEN function, there will be duplicate data, which will not achieve the random and unique purpose. It is better for RAND to get a list of non-repetitive random numbers, and the reordering is scientific and effective.