I have a challenge in extracting distinct 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.
Your help will be greatly appreciated.