2
three
four
5 2. Enter the names of five people in B 1 to B5 3. Enter the formula = rand () in C 1 to C5 4. Enter the formula =RANK(C 1) in D 1.
$C$ 1:$C$5), and then copy it to D2 to D5 5. Enter the formula =VLOOKUP(D 1) in E 1.
$A$ 1:$B$5
2), and then copy it to E2 to E3. 6. Use the mouse to select a blank cell (for example, A7). 7. Press the Del key for a while, and the name of E 1 to E3 will not stop beating. Let go and stop, don't press the Del key. 8. Hide columns A to D and enlarge column E to highlight the effect. Interpretation of each function RAND-RANK- Rank (here is the ranking of random numbers) VLOOKUP- search related names by ranking. Supplement: if I want one ... don't I need to copy it in the other two boxes of E 1 ... > that's right. Another sample is used to protect cells ... I'm afraid I'll press DEL to the wrong left ... Can I use > > and I can't find it for the time being. Recalculation is only performed when the contents of a cell need to be modified. You're welcome.