This should be a simple excel problem to an expert unlike me.
There is currently four columns:
(Col A) is (Win/Lose)
(Col B) is (Score)
(Col C) is (1,2,3) - checks to see if Score returns either 1, 2 or 3 - it it does returns (1) else (0).
(Col D) is (Running Total) - resets after a gap of one (0) (when score doesn't return either 1,2,3)
(Col E) is (Running Total 2) - same again except resets after a gap of 2 (0, 0)
What I want to do is be able to automate this process as I have demonstrated across three worksheets to make it easier to understand. This needs to be achieved by formulas as I want to be able to easily take it from this workbook to another.
Hope to speak soon.
PS: I am a previous ScriptLance member think my account is in process of being updated.
I forgot to say the formulas needed are for Column D and Column E
Thanks for your interest