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.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackHere'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.