Hey

Excel community! 👋 Another fascinating challenge from a connection (see image below ⬇️). Let’s put our heads together and solve this!

🎯 The Challenge:
In the attached data (Photo), you’ll see:
Column B: Buyer names (e.g., HP, Dell, Lenovo)
Column C: Style codes (e.g., 31190002514 TAB, 9AXDDHAS-204)

Your task:
👉 Count unique styles for each buyer
(Example: If "HP" has 2 different styles, show "2" in the "Unique Style" column)

🌟 Your Mission
One formula to populate the "Unique Style" column (Column F).

The formula should:
Ignore duplicates (count each style code only once per buyer).
Update automatically if new data is added.

💡 Imagine you’re analyzing product diversity for each brand!

❤️ Why Join?
Perfect for inventory analysis, sales reports, or data cleaning!
Boost your skills in real-world scenarios.
Beginners welcome — great learning opportunity!

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

📸 Image: Raw data table (Photo)

Excel DataAnalysis Spreadsheets ExcelChallenge LearnExcel
PS: Share your formula in the comments! I’ll reveal my approach in 24 hours. Let’s learn together! 😊

Ready? Show us your Excel magic! ✨

To see the solution and more other possible answer please click here