COUNT CONSECUTIVE ENTRIES IN COLUMNS
 

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

COUNT CONSECUTIVE ENTRIES IN COLUMNS
 

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

=IF(A2=A1,B1+1,1) and copy down
--
Gary''s Student - gsnu201001


"micoz" wrote:

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