I am looking to display the the number where the event has occurred in sequential order.
Column C has N for true, or O for false (Wingding font)
What I want to do is display the running total for true events that occurred sequentially without interruption for the entire year. The first example shows the sequence in the last column. (counting from 6 to 13)
Kind of if C4=n, then 1, ""; then I guess nest a SUM to keep a running total?
Part two. Hopefully the sequence will extend to the next year. So in the second example you can see the current year, and below is the sequence from the previous year. Short example is 2013 ends with 8, so 2014 will start with 8, and add on from there.
Thanks
Kent
Mo 10/14 n 3.103 0:33:15 10:43 389.0 5.60 22:00 1.0 1.0 H 3.1 6
Tu 10/15 n 8.014 1:24:23 10:32 1007.0 5.70 13:10 1.0 1.0 H 5 7
We 10/16 n 8.045 1:23:40 10:24 1004.0 5.77 19:45 1.0 1.0 H 6.2 8
Th 10/17 n 2.013 0:21:03 10:27 247.0 5.74 05:10 1.0 1.0 W 2 9
Fr 10/18 n 6.706 1:10:05 10:27 824.0 5.74 13:50 1.5 1.5 H 6.2 10
Sa 10/19 n 2.110 0:22:13 10:32 263.0 5.70 05:20 1.0 1.0 W 2 11
Su 10/20 n 3.104 0:32:41 10:32 386.0 5.70 14:50 1.0 1.0 H 3 12
Mo 10/21 n 2.012 0:20:51 10:22 247.0 5.79 05:20 1.0 1.0 W 2 13
2013 2014
2012 0 2013 8
N 1 n 9
N 2 n 10
N 3 n 11
O n 12
O o
N 1 o
N 2 n 1
N 3 n 2
N 4 n 3
N 5 n 4
N 6 n 5
N 7 n 6
N 8 n 7