2. Use rand function to generate random numbers in the second auxiliary column? = Rand ()
3.rank is used to rank in the first auxiliary column.
Finally, use the search function to find the filter.
Is the formula in the figure an array formula that can be ctrl+shift+ Enter? End.
It can also be changed to = vlookup (row (a 1), $ a $1:$ d $10,3,0)&; "?" & ampVLOOKUP(ROW(A 1)，$A$ 1:$D$ 10，4，0)？ Pull it down and use it.
I can't see the picture. Hi, I ... ...