I'm trying to do some data analysis on excel and having some trouble.
So the problem is I need to make the last consecutive number on a list count but the rest needs to deleted to 0. For example, column A has the first number as a single consecutive number "1" therefore column B's equivalent number stands and is converted to column C as "1". But the next numbers in "A" are 1 and 2, the last consecutive number in this case "2" stands and so column B's equivalent is transferred as 0 to column C but the equivalent for "1" is 0 regardless of what is in column B.
Another way of putting this is that if I have in column A 1,2,3 and column B 1,1,1 then column C should have an answer of 0,0,1 as only the last number of a consecutive chain is valid and the others will be converted to 0. So this can be again column A 1,2 and column B 0,0 then column C will be 0,0 because only the last number is taken, coincidentally, this is also 0.
Thanks for your help in advance!
Solved by I. J. in 22 mins