New FILTER & UNIQUE formulas

Hi all,

So I've been playing with the new formulas that Excel released to all O365 users a few days ago. FILTER and UNIQUE turn out to be extremely useful especially with the new spill feature. However, I am struggling a little with applying criteria correctly by using a boolean logic as you would do with SUMPRODUCT etc.

example 1:

I want to filter out all values that contain the letters "STP", and then get the unique values of that list. Not sure I can use wildcards here?

Please Login or Register  to view this content.

Example 2:

get all unique values from the range that are NOT blank or "PANTS"

Please Login or Register  to view this content.

any ideas how to achieve these two above?

esbencito,

Any chance you could post a sample worksheet as per the yellow banner above?