| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Create Unique Reference Numbers for rows of information
Hi
I would like to be able to create a unique reference number automatically when entering a record in the row. Can this be done? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to Create Unique Reference Numbers for rows of information
Dear Dave
Col A will have the unique reference number A1 = Header A2 = If(B2="","",Row()-1) Paste the formula to the below cells.. If this post helps click Yes --------------- Jacob Skaria "Dave" wrote: Hi I would like to be able to create a unique reference number automatically when entering a record in the row. Can this be done? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup without Unique information | Excel Discussion (Misc queries) | |||
| How do I create a unique spreadsheet reference? | Excel Worksheet Functions | |||
| I want to create unique randomn numbers | Excel Discussion (Misc queries) | |||
| Renaming Sequential Rows to create serial numbers | Excel Worksheet Functions | |||
| Can a macro create a hyperlink with unique cell information? | Excel Programming | |||
Hybrid Mode
