I have a column of scores. Assume it is column B. How would I go about tracking the most consecutive 100+ point streak within the column?
The easiest way to do this would be to use column C as a 'helper' column. Assuming your actual data starts in B3, I'd use the following:
C3 =IF(B3>=100,1,0) C4 =IF(B4>=100,C3+1,0)
Then depending on your layout, I'd put a total at the top or bottom of column C with the following:
If you use a similar approach for each of your scoring columns, you can then find out which one has the longest streak. You could optionally hide these helper columns once they're working.