Prev: "Disclaimer"
Next: Time format shows default of 12:00 AM
From: micoz on 6 Feb 2010 22:35
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
From: Gary''s Student on 7 Feb 2010 11:04
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
 | 
Pages: 1
Prev: "Disclaimer"
Next: Time format shows default of 12:00 AM