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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Consecutive counts with conditions in excel 0
Consecutive Cells 1
Return Summed Count of Multiple Consecutive Numeric Values 4
counting consecutive absences 6
Count & Sum Consecutive (2x) appearance of Specific Numeric Values 2
Formula to count number of sequential days in a row 2
Count consecutive absences with a limit 7
Count consecutive cells then start over 9

Back
Top