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
|