Sequential numbering based on same event

Hello

I have a list of of numbers which after I sort them by ascending order, I want to have a new column beside it with their order number, starting at 1.

As per the attached file though, there is an event ID column which I sort by first, and then sort by the column in Blue.

So for each new event ID, I would like the numbers to start from 1 again and so on.

Example is the pre-filled column in yellow...

Screenshot (60).png

Is this possible?

Further, if the numbers in the blue column are identical, is it possible to have the sequential numbers the same? If not this is no real issue...

Thanks heaps
Dan

Put this formula in F2:

=IF(COUNTIFS(A$2:A2,A2,D$2:D2,D2)=1,COUNTIF(A$2:A2,A2),F1)

then copy down.

Hope this helps.

Pete

Pete, you are a genius... thank you, this works perfectly.

Much appreciated
Dan

Glad it worked for you - thanks for the rep.

Pete