Problem:
Randomly selecting one of the letters from the range A1:C4.
Solution:
Use the INDEX and RANDBETWEEN functions in the following formula:
=INDEX(A1:C4,RANDBETWEEN(1,4),RANDBETWEEN(1,3))
Problem:
Randomly selecting one of the letters from the range A1:C4.
Solution:
Use the INDEX and RANDBETWEEN functions in the following formula:
=INDEX(A1:C4,RANDBETWEEN(1,4),RANDBETWEEN(1,3))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks