Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incremental Counter Function in Excel
I am developing a form in Excel that will have multiple users across several
facilities. Each time a user accesses the form, the form needs to have a unique incremental number, so the form can be referenced for use later. I was thinking that a counter would be the easiet function, but have been unable to find anything or create anything that would create this number. The number must increment by 1 each time the form is used - ex: 10001, 10002, 10003, etc... Does anyone have any ideas on this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incremental Counter Function in Excel
You may want to look at how J.E. McGimpsey does it:
http://mcgimpsey.com/excel/udfs/sequentialnums.html He shows a couple techniques. Decatur Aggie wrote: I am developing a form in Excel that will have multiple users across several facilities. Each time a user accesses the form, the form needs to have a unique incremental number, so the form can be referenced for use later. I was thinking that a counter would be the easiet function, but have been unable to find anything or create anything that would create this number. The number must increment by 1 each time the form is used - ex: 10001, 10002, 10003, etc... Does anyone have any ideas on this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OTHER EXCEL FUNCTION COUNTER SOLUTION ? | Excel Worksheet Functions | |||
Incremental Formulae in Excel | Excel Worksheet Functions | |||
incremental counter | Excel Worksheet Functions | |||
Function Counter | Excel Programming | |||
IF Function in incremental charges | Excel Worksheet Functions |