I have a bunch of data of 1's and 0's in different columns. I need help tracking how many 1's, turn to 0's from one column to the next.
For example using the following data:
1 1 0
1 0 0
1 1 1
I would need the formula to show in a row I would be using for totals:
0 1 1
as there was 1 change from column 2 to 1 (the second row) and 1 change from column 3 to 2 (the first row)
Thanks!
Bookmarks