Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere's my solution. That one was really tricky, but cool to explore the dynamic replace tool! Thanks @kelly_gilbert for the guidance on this one!
Quite sneaky level of difficulty - thank you @LordNeilLord , @JReid @AnandKumar1
Final solution is pretty small - this won't give anything away - detail of each piece in the spoiler below
@estherb47 wrote:I'd love to figure out a more streamlined approach. Here's my go at it, not very different from anyone else.
Sometimes I do actually miss the INDIRECT function.....
ABSOLUTELY - and Indirect function would have been super valuable in a dozen places at work too (not just weekly challenges).
I think there's an idea out there for Indirect @estherb47 - if not, log it and I'll definitely vote for it!
Hi @SeanAdams . I just checked the ideas, and indeed there is one already there. And wow would it help!!!
Like. Rinse. Repeat.
Cheers,
Esther
I liked this conversion challenge. Not something you run into everyday, but it gave a good opportunity to showcase the the dynamic replace function.