SOLVED

# Unique list only including certain criteria.

Copper Contributor

# Unique list only including certain criteria.

Trying to consolidate my tabs into 1 Single tab that generates a unique list based off specific criteria.

Attached is what I currently have, and the last tab is what i'm trying to do but having trouble getting to work right.

3 Replies
best response confirmed by Rodney2485 (Copper Contributor)
Solution

# Re: Unique list only including certain criteria.

This is what's happening when the SEARCH part of the formula is isolated:

A vector of FALSE entries.

Try this one with XMATCH:

``````=LET(
filtered, FILTER(
),
UNIQUE(filtered)
)``````

# Re: Unique list only including certain criteria.

Thanks, that worked perfectly!

# Re: Unique list only including certain criteria.

You're welcome!
1 best response

Accepted Solutions
best response confirmed by Rodney2485 (Copper Contributor)
Solution

# Re: Unique list only including certain criteria.

This is what's happening when the SEARCH part of the formula is isolated:

A vector of FALSE entries.

Try this one with XMATCH:

``````=LET(
filtered, FILTER(