Oct 02 2020 06:18 AM
The example is based on 100 but you could also do it in degrees like a compass rose. I have a list in "A" of values that basically depict points that go around a circle. I need to have the result column B continually count up so each time it passes "North" say, it adds another 360 or set value ( 100 in my example) so that the values continue to increase from the previous cell. IE: 2.5 times around the circle would result in "250". SUM does not work, it gives erroneous results for what I need. I don't even know if this is possible without VBA or some sort of code but that's way beyond my capability (and then I'd be unable to t/s or modify it). TIA!
Oct 02 2020 06:37 AM
B2 and copy down
=IFERROR(A2+IF(A2<A1,B1-A1+100,B1-A1),A2)
Oct 02 2020 06:42 AM
Oct 02 2020 06:57 AM
After working with that I realize I spoke too soon, that doesn't work, it's only referencing the B column I put in manually. I need the formula to actually generate that B column correctly! @Peevil
Oct 02 2020 07:20 AM
Oct 02 2020 07:26 AM