Is there a way to generate a random letter of the alphabet to a cell?
I set up letters A-Z in a column but I can't reference it from a random number.
[Re-Titled by Moderator]
drrichard wrote:
Is there a way to stop the updating, maybe by permanently turning the letter that's generated into a regular character?
Select the cell(s) with the formula, command-c to copy, Edit > Paste Formula results. That removes the formula.
SG
You could use this formula directly:
Thank you!!!
Is there a way to save a custom function or formula? I have not found such a menu item.
There are no custom functions or formulas in Numbers.
Just bear in mind that RANDBETWEEN() will update (and generate a new value) any time any cell on the sheet is edited. That may be OK.. just something to be aware of.
Is there a way to stop the updating, maybe by permanently turning the letter that's generated into a regular character?
Thank you for the help.
Generating random letters in Numbers
