Is there a secret code in this data? [Excel Homework]
Are you ready for a fun Excel challenge? Read on then…
You are a nautical transport manifest analyst at New Donk city harbor. But you also have a secret identity. You are a spy for Global Intelligence Organization. As part of routine inspection of cargo details, you came across a list of shipping codes that look suspicious.
Your mission – Find the secret codes
Step 1: Download the sample data.
Step 2: The secret code is 007. If you find it anywhere in the shipping number, then it is a Yes.
For example: the shipment number 1230450789 has the code since you can spot 007 when reading from left to right. The code can be separated by other numbers, but as long as it is present in whole, the answer is Yes.
Step 3: You can use formulas, Power Query, VBA or rugged good looks to solve this.
Go ahead and post your solutions in the comments area.
Note: when posting your formula answers, just assume B4 has the shipment number.
Want more problems to solve?
As a transport manifest analyst life can be a bit drab. Worry not, I have several more challenges for you. Solve these problems (click on title or image).
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Number to Words – Excel Formula||Excel Dynamic Array Functions – What are they, how to use them, Examples and FAQs »|