**Worksheet Formulas**
Cell | Formula |
---|
F2 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
G2 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
H2 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
I2 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
J2 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
F3 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
G3 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
H3 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
I3 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
J3 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
F4 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
G4 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
H4 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
I4 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
J4 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
F5 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
G5 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
H5 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
I5 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
J5 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
F6 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
G6 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
H6 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
I6 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
J6 | =VLOOKUP(RAND(), $A$1:$B$4, 2, TRUE) |
---|
A2 | =IFERROR(RANK(C2,C$2:C$4,1), "") |
---|
A3 | =IFERROR(RANK(C3,C$2:C$4,1), "") |
---|
A4 | =IFERROR(RANK(C4,C$2:C$4,1), "") |
---|
<thead>
</thead><tbody>
</tbody> |