Excel Campus License Plate Challenge: The Down & Dirty Edition

/in /by

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/guerrilla-data-analysis-3rd-edition/
#ExcelChallenge
#ExcelOnFire

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com
My old blog: http://datascopic.net/blog-2-2