I have data that I need to be able to count the number of days a value has been in and also what it moved into next.
For instance, how long was the row in a 0, what came after that, how long was it that value, what came next, how long, and so on...
This is a massive spread sheet and I need to track the delay and movement of these values.
I've already used Countifs for the general counts, but I can't figure out how to combine that with the order of events. I'm looking for a "summary" that I can put off to the right next to this data.
Is this possible to do cleanly?
0 0 0 0 0 0 3 3 3 3 3 3 3 3 1 1 1 1 1 1 1 1 1 1
0 0 0 0 0 0 6 6 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7
0 1 1 1 1 1 1 1 1 1 1 1 1 1 5 5 5 5 5 5 5 5 5 5
0 3 3 3 3 3 3 3 3 3 3 3 3 3 3 1 9 9 9 9 9 9 9 9
Here is an example for the first row of the result that I want:
(I need it do it for all rows though..)
...................................................................0 3 1
0 0 0 0 0 0 3 3 3 3 3 3 3 3 1 1 1 1 1 1 1 1 1 1 | 6 8 10
0 0 0 0 0 0 6 6 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7
0 1 1 1 1 1 1 1 1 1 1 1 1 1 5 5 5 5 5 5 5 5 5 5
0 3 3 3 3 3 3 3 3 3 3 3 3 3 3 1 9 9 9 9 9 9 9 9
Let me know if I need to clarify..
Bookmarks