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 trouble getting to work right.
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) )
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!
