Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEATough in vertical layout. Got it to pass the macro test.
Glad there is an impute tool now, would have been much simpler, but not too bad. Took longer than I would have liked, but had to troubleshoot getting the macro to work a little. Good practice problem.
Fun challenge. A few misinterpretations as I initially did the averages for departments by store instead of overall for the fill ins, but once I made that adjustment I was good.
Here's my solution. It's not pretty but it works. What I couldn't get working was the macro, but I opened it up and saw what test it was performing and did the test manually to verify that I had the correct result.
By the way, I tried using the old icons, but developed a splitting headache in about 3 minutes. I kept the vertical layout for this exercise, but if I was going to use it regularly, I'd be switching my monitor to profile mode.