Hi All,

Any help appreciated by this excel numpty.

The data in question is a column of text with multiple values in each cell (O7 to O15). Outside of this range, two cells (O2 & O3)allow the user to select values (also present in the data) to be referenced in the following queries. This set up is copied across to another sheet to support two different queries.

Sheet 1 query purpose
To filter to show rows that contain (but not exact match) both values as selected in the referenced cells.

So far I have tried the following but the cell referencing hasn't worked although the formula doesn't bounce;

=IF(SUM(COUNTIF(O7:O15,{"$O$2","$O$3"})),"TRUE","")

Otherwise I have tried out different filtering opens but have had problems with getting excel to both reference values in different cells and use CONTAINS as opposed to EXACT match.

Sheet 2 query purpose
To filter to show rows that contain one value but not contain the other.

Thanks.