hello to all who are able to help me I apologize in advance because I know it's somewhere on stackoverflow but I can't find it

I need it to automatically assign me a number to the selected column (do not look at the date in columns C and D) in column B there are unique repeatable names and I want it to have a number assigned depending on which time it has already been written and I would like it to be dependent on column E as well

I don't want something like that

just something like this

Thanks for Help

I looked on the website but I couldn't find it, I know it's there somewhere

CodePudding user response：

try in A2:

=INDEX(COUNTIFS(B2:B; B2:B; ROW(B2:B); "<="&ROW(B2:B)))