I use this formula to extract some cells from Worksheet "Suppliers" based on a certain condition and load it into Worksheet "P&L". The formula works fine but I do not know how to modify it to exclude the duplicate values.
I have attached a sample file to demonstrate what I need to do. The duplicate cells are highlighted in Yellow, which I need to exclude. If the formula I use cannot be modified to do the job, I appreciate your input with another one.