Forum Discussion
Solved
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 t...
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( 'Load Tracker'!$M2:$M5000, ISNUMBER(XMATCH('Load Tracker'!$D2:$D5000, K1:K4, )) ), UNIQUE(filtered) )
Thanks, that worked perfectly!
You're welcome!