Very impressive, it's crazy how quickly you adapted to the borders issue and completed the last bonus
@MattPlaysExcel8 ай бұрын
You solved Bonus 2 and 3 so fast. I'm very impressed. Thanks for posting this! Very interesting to watch someone else's approach. I do wish you'd shown your score and reacted to it a little bit, even if you didn't go back and try to solve them again. Also, you ran into the same issues I ran into when trying to do a walkthrough of this case. On level 6, where you actually can leave the designated area. And I'm glad to see you got the same answers as I did on Level 8. The way you solved Bonus Question 5 was similar to Diarmuid Early and missed the double occurrence that appeared in one of the rounds.
@andrew_ngai8 ай бұрын
Thank you! Will keep that in mind next time :) Might be an issue with the answers if we all got the same issues. Your comment on B5 is interesting though. From the question wording, I think it's not clear whether double occurrences should be treated as two separate instances, or that "3 in same cell" simply satisfies the "2 in same cell" condition. Unfortunately there'll always be some questions where it's easy for different competitors to interpret slightly differently.
@LorenzoFoti9 ай бұрын
I watched this at 2x speed, I am afraid I will need to watch it again at (at most) 1x speed...! Impressive!
@abdanomer8 ай бұрын
I watched in 0.25 Speed to get something!
@cokrofidian11 күн бұрын
Hi Andrew, Just want to make sure In the tab Answer Level 8 No. 146 the answer is 67 instead of 84 Is it right? My calculation is 84 too I wonder if the answer in the case file was wrong. What do u think?
@asadyousafzai29049 ай бұрын
This is the level I aspire to achieve.
@abdanomer8 ай бұрын
Lovely I like it a lot!... Why Ctrl+Shift+W make your cells light blue! how is that? is it a shortcut you made?
@MattPlaysExcel8 ай бұрын
Likely a macro in his Personal Macro Workbook
@abdanomer8 ай бұрын
There is some difference from the answer sheet in Level 8, did you check that !!
@andrew_ngai8 ай бұрын
yep its this, just a simple cell colour macro :)
@asadyousafzai29049 ай бұрын
Before watching this video I thought I was 4/10 in excel and now I think I am 1/10