One of my friends, working remotely as an analyst, faced an interesting Excel challenge. He regularly receives an Excel file with thousands of product codes listed in a column.
👉 Count how many times a specific substring (PRDX, prdx, PrDx, PRdX) appears in the list — but here’s the twist:
🔒 Restrictions:
The substring check must be case-sensitive (e.g., "PRDX" ≠ "prdx")
The file is in a fixed format — no extra helper columns can be added
The solution must be dynamic and formula-based
Sounds tricky?
Below shared the picture of the excel file.
📁 Try It Yourself!
If you want to try yourself share your mail address in column below will send the Excel file there.
🧠 Your Turn:
Can you solve this using any formula?
Drop your thoughts in the comments 💬
Let’s learn Excel in real-world ways.
To get the possible answers please answer click here
0 Comments