Thank you FlameRetired but how do i get the cell equivalent?
Tony say in row 1 (A:K) i have
B A A A L L L A A A B
what I'm trying to do is count the number of A's between the third occurrence of L and 2nd occurrence of B
So i figured how to find the 2nd occurrence of L but not the 2nd B.
Bookmarks