Hey hashtag # 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...