excel problem

Question

i have some names that are repeated often i want to use a function that uses persons names and nth time repetition of it as arguments to give me the row which indicate the person name and nth repetition of it

Answer 1

This assumes your names are in C1:C12

I created a drop down in F3 called Names Drop Down

In cell G3 I get the count telling me how many times that name is repeated with formula =COUNTIF(C1:C12,F3)

In cell H3, I then get the max row where that repeated name resides using formula =MAX(IF(F3=C1:C12,ROW(C1:C12)-MIN(ROW(C1:C12))+1))

Feel free to message me with any questions