Hi!
I have a problem where I have nulls in a column, and I need to fill the nulls based on certain rules.
The @ tracks will only ever be null, 1 or 2. If the null, or multiple nulls, have a 1 and a 1 on either side of them, the output should be 2. Similarly, if the null(s) have a 2 either side, the output should be 2.
If the null has a 1 AND a 2 on either side of it, the result should be 1. Note that this needs to be done by account code i.e. the formula must only take into consideration all the # tracks within an account code.
If there is a null at the very end or very beginning of an account code, the number selected (1 or 2) must be the most recent # tracks to the null.
See below for a desired output as an example. I have attached this in excel.
Please help, I've been stuck on this for a while now!
Thank you in advance!
