My "live" attempt at Road to Las Vegas 2024 Battle 1

[@HadynWiseman]

Very impressive, it's crazy how quickly you adapted to the borders issue and completed the last bonus

[@MattPlaysExcel]

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_ngai]

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.

[@LorenzoFoti]

I watched this at 2x speed, I am afraid I will need to watch it again at (at most) 1x speed...! Impressive!

[@abdanomer]

I watched in 0.25 Speed to get something!

[@cokrofidian]

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?

[@asadyousafzai2904]

This is the level I aspire to achieve.

[@abdanomer]

Lovely I like it a lot!... Why Ctrl+Shift+W make your cells light blue! how is that? is it a shortcut you made?

[@MattPlaysExcel]

Likely a macro in his Personal Macro Workbook

[@abdanomer]

There is some difference from the answer sheet in Level 8, did you check that !!

[@andrew_ngai]

yep its this, just a simple cell colour macro :)

[@asadyousafzai2904]

Before watching this video I thought I was 4/10 in excel and now I think I am 1/10