How to create an automatic generated number for a spreadsheet

  • Thread starter autogenerated numbers
  • Start date
A

autogenerated numbers

Im trying to create a spreadsheet with database information but I want to
every time I open it have a diferent generated number in a determined cell.
 
P

PJFry

=RAND() will give you a random number between 0 and 1. It changes anytime
the sheet recalculates.

If you need a value larger than 1, you can string a bunch of RAND's together:
=ROUND((RAND()+1)*(RAND()+20)*(RAND()*41),0)
 
Top