COUNT CONSECUTIVE ENTRIES IN COLUMNS

  • Thread starter Thread starter micoz
  • Start date Start date
M

micoz

i have a column that returns "UP", "DOWN" OR "FLAT" BASED ON ANOTHER FORMULA.
MY QUESTION IS, I WOULD LIKE TO START ANOTHER COLUMN THAT KEEPS A RUNNING
TOTAL OF HOW MANY CONSECUTIVE DAYS HAVE BEEN POINTING EITHER "UP" OR "DOWN".
IT NEEDS TO RESET THE COUNT EACH TIME THE DIRECTION CHANGES.

Thanks

micoz
 
Say your data is in column A. In B1 enter 1. In B2 enter:

=IF(A2=A1,B1+1,1) and copy down
 
Back
Top