by alrodopial » Thu Nov 03, 2022 6:54 pm
1. if(rngE2=In Play"and rngF2="Suspended") or if(rngE2=In Play"and rngF2="Closed") then race ended
2. Create a variable to store the previousStatus and compare it with currentStatus
if preStatus = "In Play" and ( rngF2="Suspended" or rnfF2="Closed") then race just ended
preStatus = currentStatus 'update variable , will be used in next update