Calculating a series of ongoing events
Solved
jesaispas47
Posted messages
98
Status
Membre
-
Anonymous user -
Anonymous user -
Hello,
I have a small issue with Excel and I would need your help.
To keep it simple, I have a calendar with Lyon's results and I've used a formula to count the match sequences where there were fewer than two goals. So far, everything is working, there are no issues.
Where I'm stuck is how to get the current series marked in G7? (so 4)?
If anyone has an idea, I'm open to suggestions :)
Thank you in advance
--
"All knowledge is an answer to a question."
I have a small issue with Excel and I would need your help.
To keep it simple, I have a calendar with Lyon's results and I've used a formula to count the match sequences where there were fewer than two goals. So far, everything is working, there are no issues.
Where I'm stuck is how to get the current series marked in G7? (so 4)?
If anyone has an idea, I'm open to suggestions :)
Thank you in advance
--
"All knowledge is an answer to a question."
Thank you for coming back with the answer ;)