How to create an automatic generated number for a spreadsheet

  • Thread starter Thread starter autogenerated numbers
  • Start date 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.
 
=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW TO AUTOMATICALLY GENERATE NUMBERS IN EXCEL 1
Automatically generating spreadsheet B from spreadsheet A 1
random number in a cell 1
How to automatically combine several worksheets into on ene worksheet 4
Macro for a one time triggered copy of cell value 8
Locking updated cells 1
Random Numbers 4
Locating Source Data in Master Spreadsheet 3

Back
Top