Hi guys. I am a new member-i had a friend recommend excel forum and he said you guys were very knowledgeable about helping with excel.
I have a (hopefully) quick question
I have a column "M" with 2500 cells of either 0,-1,1. I want to create a column in N, that keeps a cumulative count of the number of times -1 or 1 is reached and resets every time a new value is reached (and disregards the value of 0)
My data starts like this: I want it to say this:
0 0
1 1
1 2
0 0
-1 -1
-1 -2
-1 -3
1 1
1 2
1 3
1 4
1 5
0 0
etc...
Thanks guys I really appreciate all of your help!![]()
Bookmarks