Filter M is helpful when we want to analyze a group of games in order. When we put M1, it's the latest game, and the following numbers mean the next games. Below are some examples of how we can use this filter in some formulas:
- =VSCOUNT("*4A#; M1") - counts the kill attacks of player number four in the latest game
- =VSPER(VSCELL("*(1)A#;(2)",$B$2, C$2) - counts the percentage of kill attacks combined with VSCELL function, where in cell B2 is the player number that we want to analyze and in cell C2 is the M filter.
To automatize the M filter, we can use
- =CONCATENATE("M," ($B$3-1)) - where in cell B3 is the number of games that we want to analyze.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article