Challenges: Final Friday Fix: June 2019 Challenge
28 June 2019
On the final Friday of each month, we’re going to set an Excel challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights only!
Auto Fill Down
You may be familiar with built-in Fill function in Excel…
…would it be helpful in this case? Imagine you have thousands of rows in the below structure, how would you fill the blank investment column properly?
So that you will have a beautiful table like this, ready for all of your lookup functions:
This is an Excel challenge (not a Power Query one, whereby it’s trivial).
Sound easy? Have a go. We’ll publish what we think is the best solution in Monday’s blog. Have a great weekend!
