Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEANot the simplest solution but a robust one.
lazy guy answer without too much formula. could reduce 2/3 of the workflow using the formulas. Make columns could be used for more efficiency
Runtime is not that bad tho.
This was a fun one! First time using spatial plotting, but I figured it out. 🙂
My solution - I try to use as basic a tool as possible, in the most basic, step-by-step way as I use these challenges as a fun way to train up the rest of my team.
I misunderstood the third question and assumed that "neighboring" meant "adjacent." So I solved for that first then checked the solution and realized the question just meant in another state. So both solutions are shown below.
Thanks @Blake
I got it, just had some spare time to kill :'-) 😁
Thanks for the submission :folded-hands:
(edit : it seems emojis are not rendering properly)
🙏
Cool topic learning about the highest peaks in the U.S.
@patrick_digan your solution file is a blank start file. I am interested in seeing the inner workings of your formula tool in the Highest Peak transformation. Can you please reattach when you get a chance?