This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I haven't done much workflow utilizing iterative macro and kinda getting stuck. Appreciate any guidance on this.
I have a dataset with 3 datapoints. Number, Moved To, Moved From. A number can transfer multiple times, but regardless of how many times it has transferred, I need to associate it with the original Number.
I've used an iterative macro to work my way down the numbers to the original, since 3 is originally a subset of 2 and therefore 1 i've come to that conclusion but it can be adapted if that's the wrong assumption!