Do you need the output in a particular way? if not you can probably do something like this (assuming names are sorted /separated)
C3 =IF(B3="N", IF(C2>=1, IF(B2=B3, C2+1, 0), IF(B2=B3, 2, 0)), 0)
Col A = Name
Col B = Result
Col C = Formula
Values start row 2, formula starts at row 3
Quote:
|
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.
|
You can probably use a pivot table to sort and display the tables results...i.e. showing how many 2/3/4 in a rows total sum counts