Using RAND and RANK to get Random Numbers in Excel Without Duplicates · In the adjacent column (B), use the RANK formula as follows: =RANK(A2, $A$2:$A$11).
確定! 回上一頁