Well, I thought I was pretty clear. (Just goes to show you!)

What I am actually looking for is a way to find the second match of a
value in a single row range.

So, like in my sample data above, if I've given the range B1 through G1
the name "JAN", what would the formula look like to find the location
of second match of the name "Jones"?

Hope that clarifies my query.