Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAA little tricky but fun to work out
Great challenge. I built the workflow out then converted it to a macro for the second dataset.
Solved! I could not remember the name for the Substring formula and had to look at the answers, though I knew it existed.