Is it possible to link a cell to another random cell that is within a certain range? For example, if I have a table labeled “Cards” that has 52 cells (Let’s say it has a single column (A) and 52 rows). Then I have a cell in a different table that table that I want to = one of the 52 cells at random. So, the first time I run the cell, it might equal the 3 of clubs, but the next time it might equal the 5 of diamonds.
I am playing with setting up a table that generates a random 5-card hand. I haven’t solved for duplicates yet, I figured I’d tackle that next. ;-) I briefly thought about using the RANDBETWEEN function to replace the number in the cell reference, but can’t figure out how to insert a formula into another. Ex: =Cards::A(RANDBETWEEN 1,52).