Home > OS >  Calculate Hat Trick Wins in a Matrix
Calculate Hat Trick Wins in a Matrix

Time:05-21

I would like to have a script or formula to calculate the number of three consecutive "W" values on a row of 64 cells from left to right and display the result in a column labeled "Hat Tricks". The formula/script must be able to be copied to multiple other rows.

I have drafted an example sheet enter image description here

  • Related