Excel Campus License Plate Challenge: Odd vs. Even Days & License Plates
Jon Acampora of Excel Campus has an interesting challenge: • Excel Formula Challenge: Even or Odd ...
Yellowstone National Park has a system where cars with even number license plates can come into the park on even numbered days. Odd number plates can enter on odd dates.
But what if a license plate doesn't end with a number? (4CE-3DQ)
What if it doesn't have any numbers? (BIG-DAY)
In this video I show a Power Query solution that uses the Information feature and the Text.Remove function.
Guerrilla Data Analysis 3rd Ed. can be purchased at (printed book or ebook):
https://www.mrexcel.com/products/guer...
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 book: Guerrilla Data Analysis 3rd Edition
https://www.amazon.com/Guerrilla-Anal...
My old blog: http://datascopic.net/blog-2-2