| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Unique Number
I am creating an Invoice template in which I need it to generate a unique
random number each time the spreadsheet is opened. Anyone have any ideas that I could try? Thanks Tom |
|
#2
|
|||
|
|||
|
You will need to generate a random number, which is easy, but you will need
to compare it against all others used, so you will need to store them all somewhere. As simple incrementing number as Andy responded on seems easier to me. -- HTH Bob Phillips "Thomas Cox" wrote in message ... I am creating an Invoice template in which I need it to generate a unique random number each time the spreadsheet is opened. Anyone have any ideas that I could try? Thanks Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| making a number be text | Excel Worksheet Functions | |||
| unique sequential number excel 2000 | Excel Discussion (Misc queries) | |||
| how can i put a unique number in a header for a git certificat for | Excel Discussion (Misc queries) | |||
| Count number of unique items in a column that contains duplicates | Excel Worksheet Functions | |||
Hybrid Mode
