Heads or Tails Evens-Heads-Tails
HEADS WON 0 0 0
HEADS WON 0 1 0
TAILS WON 0 0 2
HEADS WON 0 0 0
HEADS WON 0 6 0
TAILS WON 0 0 1
EVENS WON 11 0 0
TAILS WON 0 0 0
TAILS WON 0 0 0
TAILS WON 0 0 0
TAILS WON 0 0 3
HEADS WON 0 0 0
HEADS WON 0 0 0
HEADS WON 0 3 0
TAILS WON 0 0 0
TAILS WON 0 0 0
TAILS WON 0 0
HEADS WON 0
EVENS WON
Above is what I want it to look like (manually entered)
I need a formula for and event of Evens, Heads and Tails
To count down to the next instance of the event, 0 (Zero) would be if event it is next
(A Blank would be better than a 0 (Zero) if possible.
I have tried formula's with Match but no good
It is really saying the event has not occurred for this many rows.
Bookmarks