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).

Job title matching problem

Can you match the job titles?
Can you match the job titles?

Any repetitions in the number?

repetitive digits in the number...
One of them has too many fives

Elevator problem

Elevator problem - excel formula homework
Can the elevator go?

IF blood pressure problem

BP - have it or not?
BP – Have it or not?

Click me for more Excel Homework Problems & Puzzles

The post Is there a secret code in this data? [Excel Homework] appeared first on – Learn Excel, Power BI & Charting Online.

Original source:

Leave a Reply

Close Menu