Assign Sequential Values Based on Unique ID Occurrences in Excel

💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

Hey David! 😊 You’re in luck! We have a great video that shows exactly how to do that: Watch Here. Let me know if you need any further assistance! 😊

We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

Thanks Bo (. But how do I get this to work If I'm not adding new data to the sheet and just want to give a record position for the first time a value appears, the second time and so on ? It looks like this video and prompt only works for when you are adding new values then the record position updates.

Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.

Thanks Bo (. But how do I get this to work If I'm not adding new data to the sheet and just want to give a record position for the first time a value appears, the second time and so on ? It looks like this video and prompt only works for when you are adding new values then the record position updates.

I wont be adding new rows and simply want to add a number for the first time something appears and then the second and so on.

Hey David, you will want to use the record position formula shown in the video Bo sent above. This will create a record position for the first instance of a number, second instance, and so on. This formula will work regardless of whether you have new values or existing data in your table. Feel free to try this formula and let me know if you have any other questions!

Thanks Tanvi Tried but seems there is some errors, everything just comes up with number 2

Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

It seems like there might be an issue with the prompting. I’d be happy to check it out for you! Could you send me the table URL, David? I’ll take a look and see what’s going on. 😊

Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.

Bo (. That would be great! still havn't quite resolved this, I've got it to work at times so not sure what it is. Here's the sheet https://app.clay.com/workspaces/305356/workbooks/wb_boSivjGyq59z/tables/t_XKkb5DPs6tT7/views/gv_nfoMdfxy9jKu