Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
This one was interesting. Of course, after figuring it out, I discovered that I was working with the old dataset. :). The new dataset was so much easier.
I was stuck on using find and replace given that it can't provide two outputs if there are two matches in one cell. For small numbers you can work around that with formula, but of course that is not the point of the exercise.