Hi all,
I have a basic spreadsheet with two columns, date and price change (%).
I'm interested in somehow tracking the # of consecutive similar values. I think the very best would be if there were cell formula that could simply count consecutive values for each single row. Like shown here:
I would imagine every new day/sequence starting with 1.
So, if it's the first positive day after a prior day down, it says 1. If the next day is positive, it says 2, if the 3rd day is positive, it says 3. Etc.
That way I could easily sort the table and find similar patterns and the associated dates.
Consecutive.PNG
Also attaching a workbook.
Many thanks in advance!
Elijah
Bookmarks