How to find the Max difference between two tests by counting number of cells between events.
I have attached a mini file. If the cell of a lot passes TEST 1 and TEST 2 its status is PASS. If a cell fails TEST 1 and TEST 2 its status is SAME. If a cell fails a test but passes the other tes...