Forum Discussion
Peevil
Oct 02, 2020Copper Contributor
Anyone know how to keep values increasing referencing another column?
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 co...
Peevil
Oct 02, 2020Copper Contributor
Wow, that was fast, Big Thanks! I see where I went wrong, too.
Peevil
Oct 02, 2020Copper Contributor
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
- DeletedOct 02, 2020it will if you start the formula in B2. The "IFERROR" part is to copy the first value into B. After that it will use the values you create.
- PeevilOct 02, 2020Copper ContributorAh, I see, I must've done it wrong because I kept getting REF! errors or all "0", I got it, it works! Thank You so much! (and you make it look easy, lol!)