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 test its status is DIFF.
For each lot I am trying to determine the Max distance by cell count from a DIFF to its nearest SAME.
What would be the best way to go about this?
Thanks
Fiona