This question is the 2nd part of a question message identically named & posted.

(Continued)
B) Statistic (Formula) 2 needed

a. Column J contains text of one of either of three types: ("IN" or
"OUT" or "GO").
This text, corresponds to the performance of the names appearing
under
columns F & H. ("Larry", "John"...)
b. If "Larry" appeared say, 200 times, in 10.000 rows of both columns F
& H,
& whenever "Larry" appeared, column J read either: IN, OUT or GO.
How would I find the number of rows existant between the identical
repetition
of these events?
("Larry" or "John"... may appear on either columns F or H, yet never
simultaneously, on the same row.)

c. Example

I) Say that "Larry" appeared a total of 200 times in 10.000 rows.
(Under either columns F or H)
II) Also, say that of those 200 appearances, 40 resulted in "IN"
for column J,
60 resulted in "OUT" for column J and 100 resulted in "GO".
III) Assume that "Larry" appeared under column F, on row 1.300 and
on that
row, column J read: "IN".
IV) The next row that "Larry" appeared under, while column J read
"IN",
was: 2.000.
V) Thus, this event was absent for 700 rows.
VI) Later, "Larry" and "IN" appeared simultaneously row 5.000.
Thus, this time, this even was absent for 3.000 rows.

The question is:

How can we find the maximum number of (row) absences
between those events?
(In the afforementioned example, the maximum number of absences=
3.000)