Let's say I have a product with different category. I want to be able to pick the product with the highest member count value. At the same time, there are other products with the same category. In this case, I can do a Sumif function to add the total member count value. Because I have products with different category and products with same category in the same worksheet, it's diffifult to built a function that would do both. I attached a document for example purposes. Any thoughts on this? Thanks!
Bookmarks