I'm not great with Python or programming in general, so I'm not even sure how to ask this question.
Basically what I've got is in the left column, and what I want is in the right column.
UniqueID POSITION a 1 a 2 a 3 a 4 a 5 b 1 c 1 c 2 d 1 e 1
I guess what I need to do is loop through the sorted UniqueID field and increment the Position field UNTIL the UniqueID changes, in which case the Position should reset to 1.
NFI how to make this actually work. I've done a lot of searching and have found some promising-looking code, but I just don't have the know-how to make it fit my problem. Sorry about my brain. My script right now looks like "Baby's first adventures with arcpy," and since this is slightly more complicated than a simple arcpy call, it's stopped me in my tracks.
I guess I'm looking for something that works as part of a CalculateField operation?