[westcoastgsr]

Working on a work project and Im having problems with a formula. If i have 2 columns name and another with result I want to set up a formula to show the amount of times in a row someone gets.

Sample:
Name Result
bob Yes
bob no
bob no
bob no
bob yes
bob maybe
bob no
bob no
ted no
ted no
ted yes
ted no
ted no

So assumeing I have different names too but only 3 results I would want the fomula to show Bob had no 3 times in a row once and no 2 times in a row once. Ted got no 2 times in a row twice.

Fuck I hate when I forget how to do things in University. All help is appreciated of course!!!