1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to add sequential numbers that are sortable

Hi all, I am working with a spreadsheet that is populated by entries in a Power Automate form. I'm trying to figure out a way to automatically generate a unique identifier on each new row, but the issue I'm having is that I frequently need to sort and filter this spreadsheet and I need the unique identifiers to remain static so I can use them to re-sort the data set back to its original order when I'm done. I know I can't use =ROW for this, and I don't think I can use =SEQUENCE either. Right now I'm using auto fill and just updating them before I do any other manipulation but I'd really like to find a way to automate. Any ideas on how this can be done?

submitted by /u/thousandtrees
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#AI-powered spreadsheet
#generative AI automation