Answer the question
In order to leave comments, you need to log in
How to generate random numbers, one for all users and without constant updates when changes are made?
Can you please tell me how to generate random numbers in Google Sheets that will not be recalculated with every change in the table?
Now they are changing steadily for me and for me and for a friend the values \u200b\u200bare displayed different.
Answer the question
In order to leave comments, you need to log in
1) Create random numbers in any cells (not target)
2) Select and copy
3) Paste into the desired cells via RMB > "paste special" > "paste values only"
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question