= indirect(" a " & amp； int(rand()*20+ 1))
Just do it.
Every time you press F9, a name can be randomly generated in B 1. If you have more than one name, and so on, change 20 in the formula to your maximum number of rows.
Why did F9 change to 0? Thank you.
Your data area contains spaces, that is, A 1 to A20 contain blank cells.
Any questions, hi me.