Hello experts,

i have a huge database of entries from a survey generated from google forms into excel. long story short i have various pivot tables and iferror(vlookup) functions. but i am doing something manually and i wonder if you can help me.

i would like to assign a number value from 1-30 for each name, always resetting to 1 at a new name. this database is pertperually growing, so names are not always in the same row day after day.

this is what i need a formula for:

john smith 1
john smith 2
john smith 3
mike ward 1
mike ward 2
jane doe 1
jane doe 2
jane doe 3
jane doe 4
jane doe 5
Bill Pull 1

etc

thanks for your help