Hi Friends,
I have a challenge in extracting unique supplier names. I have two columns with Col A = Supplier name and column B = product status - drop down. Some suppliers provide multiple products and I need to identify the supplier whose products do not meet our standards. I have created a distinct powerpivot chart to capture those suppliers but do not know how to capture the unique suppliers (5 in numbers – marked in red) in a formula instead of a pivot chart. My data starts from Cell A1:E17.
Your help will be greatly appreciated.
Taha
I have a challenge in extracting unique supplier names. I have two columns with Col A = Supplier name and column B = product status - drop down. Some suppliers provide multiple products and I need to identify the supplier whose products do not meet our standards. I have created a distinct powerpivot chart to capture those suppliers but do not know how to capture the unique suppliers (5 in numbers – marked in red) in a formula instead of a pivot chart. My data starts from Cell A1:E17.
Your help will be greatly appreciated.
Taha