China Naming Network - Ziwei Dou Shu - How does Excel arrange the duty list with formulas? Take the following figure as an example.

How does Excel arrange the duty list with formulas? Take the following figure as an example.

Randomly generate an integer, and choose Rand Before function to ensure the randomness of the number distance. Set the value to 1-5, and then enter the formula = choose(RANDBEWEEN( 1, 5), Zhang Lei, Revolution, Seed, Rainbow and Xiao Qiang) in the Name cell.