Excel Campus License Plate Challenge: The Down & Dirty Edition
Jon Acampora of Excel Campus issued a challenge to designate if a license plate is odd or even. In a previous video I showed a Power Query challenge. In this video I show a quick solution that will work, BUT, you have to be wary.
This solution isn't so sophisticated but it's worth showing you because sometimes all you need is a down-&-dirty one-time solution. Other times, you do need a solution that is robust, dynamic, and future-proof.
In this video I use Flash Fill, ISODD and IF. They work!
My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guer...
#ExcelChallenge
#ExcelOnFire
For a list of my Excel courses at Lynda/LinkedIn:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My old blog: http://datascopic.net/blog-2-2