ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   to allocate unique a number to existing rows & new insert of row (https://www.excelbanter.com/excel-discussion-misc-queries/155620-allocate-unique-number-existing-rows-new-insert-row.html)

EBC001

to allocate unique a number to existing rows & new insert of row
 
I have an existing spreadsheet with lots of info and want to give each line a
unique number. But also when a new line is added either at the bottom or
within the spreadsheet I want that line to recieve a unique number and not
alter the existing unique numbers. How do I do it


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com