Hi,

I've created a simple Excel table where each row represents an action item for a project team. Each action item (row) should be given a unique identifier (preferably a number starting from 1 and with increments of 1). The challenge is (or at least for me it is) to have this unique ID fixed as soon as it is generated. So whenever the list is sorted, the ID's should remain the same and should stay linked to the same action item. This would enable people to easily reference an ID number instead of having to reference the desciption of the action item itself. Whenever a new action item/row is added at the end of the Excel table, a new unique identifier should automatically be generated for this action item/row.

Any suggestions on how to tackle this challenge?

Thanks in advance,
Jan