| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create an automatic generated number for a spreadsheet
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create an automatic generated number for a spreadsheet
=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) -- Regards, PJ Please rate this post using the vote buttons if it was helpful. "autogenerated numbers" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking to add unique (sequential) number to already generated Use | Excel Worksheet Functions | |||
| Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
| Assign unique auto-generated number | Excel Discussion (Misc queries) | |||
| Why does Excel not multiply a number generated by an IF formula? | Excel Worksheet Functions | |||
| How do I round a formula generated number | Excel Worksheet Functions | |||
Linear Mode
