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).
Job title matching problem
Any repetitions in the number?
IF blood pressure problem
The post Is there a secret code in this data? [Excel Homework] appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.
Original source: http://feedproxy.google.com/~r/PointyHairedDilbert/~3/uFVd8ncvfyA/