ExcelHash: Greatest Threat – MAX, FREQUENCY, Form Controls, 3D Model

/in /by

ExcelHash is here!!

6 of us Excel MVPs came together to take on the challenge of making an integrated Excel solution by starting with 4 random Excel elements based on your suggestions. We have:

– MAX function
– FREQUENCY function
– Form Controls
– 3D Model

See the other awesome entries from my fellow Excel MVPs in the playlist here: https://www.youtube.com/playlist?list=PLHrPHBbDHgT0UnY1qb36YZrBwpWNJX8Lx

And be sure to subscribe to their channels for more Excel education

– Leila Gharani, This Chick’s Trouble: Excel Hash

– Mr Excel, Bill Jelen, Will Bennu Impact Earth?

– Mike Girvin, ExcelIsFun, Max Consecutive Wins for Best City
https://youtu.be/U1h2FrZFMqI
– Mynda Treacy, My Online Training Hub, Interactive Bug Menu

– Jon Acampora, Excel Campus
https://youtu.be/0ZW-h4kPlBI
VOTE for your favorite entry here: https://tinyurl.com/y9hmvelp

My solution is called “Greatest Threat”
The model allows users to set a high and low number, and one of 2 situations. The model then calculates the greatest threat. Example:

Situation A, between 8 and 96
Greatest Threat: Wasp de Fatal

Situation B, between 2 and 12
Greatest Threat: Ghost Wolf

Situation B, between 2 and 20
Greatest Threat: Vampire Earwig

Download the ExcelHash Greatest Threat workbook:
https://1drv.ms/f/s!Aoud6IXCTuoDryeEwn5p6e6Y3Kza
#ExcelHash
#ExcelChallenge
#ExcelFormControls

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2