I am looking for a formula that tells me how many consecutive matches have just occurred and hence the count for them. The Countif I know will only tell me how many out of how many. I did this once with a long series of columns with "Ifs" but lost it.
Is there a simple formula for this?
Is there a simple formula for this?