Hope I can explain this…
Column B and C are my data… I’m happy with the formula in Cell F4 downwards although I suspect that there’s an easier way to do this… Column G has my expected results in but I can’t work out the formula I need in Cell G4 downwards…
So B4 and B5 both have WM (39) 4 (they...