Adding Unique IDs to records (rows) that do not change even when some rows are deleted or added

[Pardeep Singh]

I have data in excel file where every row contains record with corresponding data. I am trying to build a formulae that can generate a unique ID for the given record (row) that won't change even when rows above or below it changes.

Tried to use timestamps to come up with something, but they keep getting triggered and changing every time some change is made in the sheet.

My data looks something like this

 

[Legacy 143009]

This system here seems to be perfectly fine. Why don't you continue like this?
A3: =A2+1

 

[Pardeep Singh]

This system here seems to be perfectly fine. Why don't you continue like this?
A3: =A2+1
View attachment 87030

@Flashbond Thank you for your reply. Issue with this system is that if a record(row) is deleted from within the data, all the records below will now have new ids. I want to keep them static.

 

[Legacy 143009]

I assume this is not possible without vba