Hey

Excel friends! 👋 A connection reached out with this real-world problem (see images below ⬇️), and I thought it’s perfect to share with our community!

🎯 The Challenge
Your goal is simple:
One formula for the "Count" column (Column C).
When a product is selected in cell I3 (e.g., "TV"), the formula should:
Show 1 for the first instance of that product.
Show 2 for the next instance, 3 for the next, and so on.
Leave other rows blank (for non-selected products).

Example: If "TV" is picked, the count should look like Image 2 👇.

🌟 Your Turn!
I’ve shared a solution with my connection, but now I’m curious:
How would YOU solve this?

👉 Comment your formula below! Let’s see how many approaches we can collect!

🔗 Download the worksheet here: https://lnkd.in/gpGNsMgy

❤️ Why Join?
Great practice for beginners AND pros.
Useful for inventory tracking, sales data, or reports!
Let’s learn together as a community! 💡
📸 Image 1: Raw sales data (Photo-1)
📸 Image 2: "TV" selected → running count appears (Photo-2)

Excel Spreadsheets DataAnalysis ExcelChallenge LearnExcel
Please share your spontaneous ideas! I’ll reveal my approach tomorrow! 😊
Let’s inspire each other! ✨

Please click here to check the answer and other possible solution