Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAOne solution is straightforward, probably similar to others, the 2nd solution involves multi-field formula tool..
I think most of us agreed on the first way to solve this, but it's interesting to see how many creative solutions people found when pushed to find an alternative.
Interesting challenge, here are my 2 solutions:
My Solution.
I believe one macro dip should be in place.