Unique, non row dependent ID

[kip820]

Scenario:

Need to assign a unique ID to ever row in my spreadsheet file. The ID can not be dependent upon the row number since I would like to have the opportunity to add rows in the future, below is an example just to illustrate what I'm looking for

| ID | Something |
| 1 | thing1 |
| 2 | thing2 |
| 3 | thing3 |
| 4 | thing4 |

If I want to add a row inbetween thing2 and thing3 it would look something like this:

| ID | Something |
| 1 | thing1 |
| 2 | thing2 |
| 5 | thing5 |
| 3 | thing3 |
| 4 | thing4 |

The number of rows in my document is several hundred so it would be nice to have some kind of formula that achieves this, preferably no user defined macros since the "soultion" needs to be implemented for several users, i.e. not just me on my local machine.

Any help would be greatly appreciated.

[AndyLitch]

If you need a unique ID for every record in your database then a macro loop with a time stamp might be the way to go

[Marcol]

This might have some mileage
Put 1 in A1
Then in A2, Drag/ Fill Down

Please Login or Register  to view this content.

This will handle Adding /Deleting rows
However you will not be able to add an indexible item in that row.