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 N7:N39 currently:
This works, but I get duplicates.
Is there anyway of gathering this list without 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 N7:N39 currently:
Code:
{=IFERROR(INDEX($C$7:$C$42,SMALL(IF($D$7:$D$42="Yes",ROW($C$7:$C$42)-MIN(ROW($C$7:$C$42))+1),ROW()-2)),"")}
This works, but I get duplicates.
Is there anyway of gathering this list without duplicates?