Geography 101 - Excel Collegiate Challenge

  Рет қаралды 502

Diarmuid Early

Diarmuid Early

2 ай бұрын

This is my test attempt at a case from the @MECC.college finals, Geography 101. This one is mostly about text manipulation.
This was a test version, and I didn't agree with all the answers... I'm not sure if either the answers or the question wording changed in the final version. (For level 3, the difference was that I counted each location as listed, but the answer was based on unique locations - so for example, there were three locations in Arizona, so I counted the letters in Arizona 3 times, but the solution only counted them once; for level 2, the difference was whether to count spaces or not.)
You can find this and other cases from the finals to download for free on the MECC website here (this case was part of 'morning finals round 1'):
mecc.college/2023-finals/fina...
If you sign up to take part, you also get access to a lot more past cases and the new ones as they come out (note you don't have to be a college student to sign up - you won't be eligible for prizes, but you can still get all the learning materials for free). You can sign up here:
mecc.college/

Пікірлер: 2
@HadynWiseman
@HadynWiseman 2 ай бұрын
Thanks for uploading, I ran into the same issues on question 3 which took me some extra time. Your let to find the capital letters in 4 was really good. I think I just pulled out the left 1 of the words of the answer locations and looked up to a new table I created for the alphabet values. Your way doing exact with the code - 64 was much better. For 5 I pretty much did it in the same way with the 2D table just didn't flatten it quite as neatly!
@DimEarly
@DimEarly 2 ай бұрын
You seem to be getting the hang of my tricks! : )
Access Beginner Tutorial
3:47:45
Learnit Training
Рет қаралды 1,2 МЛН
🌊Насколько Глубокий Океан ? #shorts
00:42
МАМА И STANDOFF 2 😳 !FAKE GUN! #shorts
00:34
INNA SERG
Рет қаралды 4,2 МЛН
Excel Origami - folding arrays with WRAPROWS / WRAPCOLS
39:07
Diarmuid Early
Рет қаралды 901
Write your own Excel functions
19:22
Diarmuid Early
Рет қаралды 1,3 М.
Photo finish! Losing Road to Las Vegas round 3 by 25 seconds
24:36
Make an Awesome Dynamic Calendar in Excel
11:34
Kenji Explains
Рет қаралды 10 М.
Is this Brand NEW Function Better than Pivot Tables?
2:34
Dave Sylvester
Рет қаралды 31 М.
The surprising value of a function that does nothing
17:14
Diarmuid Early
Рет қаралды 1,9 М.
RTLV round 1 walkthrough - Doggie Daycare by David Brown
34:11
Diarmuid Early
Рет қаралды 664