Excel Hash is back! 4 ingredients, 5 contestants and we all had to create a solution that integrates all 4 ingredients.
The Contestants:
Mr. Excel, Bill Jelen
Mynda Treacy
Jon Acampora
Leila Gharani
Oz du Soleil
The Ingredients:
XOR, a Linked Picture, a Dynamic Array function, an Icon
Here is the link to the playlist to see all videos
https://www.youtube.com/playlist?list=PLmHVyfmcRKyxfOLvOtx76xw8bbKgDvUwp
URL for voting:
https://forms.office.com/Pages/ResponsePage.aspx?id=QXR5-MbycU6IQ9aFc_tUvFg-bImtIN1EqJE5kvHXqKxURUw4RlIxUFFRT1FSWTkxR0g0MzBHVUdNQi4u
Download the workbook
https://datascopic.net/XLHash2019
#ExcelHash
#XOR
#ExcelonFire
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: http://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