China Naming Network - Ziwei Dou Shu - Excel lottery sorting is not repeated.

Excel lottery sorting is not repeated.

1. Use auxiliary columns, such as C3 to C 12. Enter the formula =rand () in C3 and drop it down to C 12.

2. Then, the unique number of 1~ 10 is obtained by using the sorting function in B3, and B3 inputs the formula: =RANK(C3, $C$3:$C$ 12).

Pull down to B 12.

If you think column C is an eyesore, you can hide it, or you can copy column B first, then paste /value/OK selectively in column B, and then you can delete it. There is even an easier way: to build auxiliary columns in other worksheets, for example, enter the formula: =rand () in C3 of Sheet2 (other cells are ok, but the formula will be changed accordingly), and then enter the formula: =RANK(Sheet2! C3, page two! $C$3:$C$ 12) dropped to B 12.