I have a list of items in cells C7:C41 - this list contains duplicates.
In cells D7:C41 I have a either "yes" or "no".
In cells N7:N39, I wish to have a list of products from the list in C displayed only if the corresponding cell in D states Yes.
I have the following array formula in cell...