Regards your question in the sample file...

The answer is 10 because there are 10 text strings in A1:A16 that precede "B2" in alphabet terms, namely:

A1 * 2
A2 * 2
A3 * 2
A4 * 2
B1 * 2
A precedes B and subsequently in terms of B1/B2 1 precedes 2