For the concantenation ID you could literaly use the countif function at the end to solve all the issues. It would ensure you get different id's every time.
I have a table with hundreds of stock trades. I would like exel to auto generate a new unique ID for each trade as I add it to the table. I would like that ID to stick with the row that contains the trade even when I sort the table by various columns (such as date or name of stock etc.). I can get excel to auto generate a number using concate but that makes the numbers long and awkward. Is there a way to get excel to auto generate a Unique ID for each trade so that I can re-sort by ID and get them back in chronological order?
If you had a date/time column, you might turn the date/time into a number and concatenate that number to the end which should generate a unique number.
For the concantenation ID you could literaly use the countif function at the end to solve all the issues. It would ensure you get different id's every time.
Sounds reasonable
I have a table with hundreds of stock trades. I would like exel to auto generate a new unique ID for each trade as I add it to the table. I would like that ID to stick with the row that contains the trade even when I sort the table by various columns (such as date or name of stock etc.). I can get excel to auto generate a number using concate but that makes the numbers long and awkward. Is there a way to get excel to auto generate a Unique ID for each trade so that I can re-sort by ID and get them back in chronological order?
Thanks
If you had a date/time column, you might turn the date/time into a number and concatenate that number to the end which should generate a unique number.