Forum Discussion
Solved
Help with creating new list off another list
Trying to pull the Delivery # for all the Customers in the list in Column J
This formula doesnt appear to be working in any fashion, tried a few others and i'm not making any progress.
=UNIQUE(FILTER('OB Summary'!B:B,'OB Summary'!L:L="DONALDSON"))
Use IFERROR:
=IFERROR(CHOOSECOLS(FILTER('OB Summary'!B2:Z1000, BYROW('OB Summary'!L2:L1000, LAMBDA(r, OR(ISNUMBER(XMATCH($J$1:$J$11&"*", r, 2)))))), 1, 2, 4, 11, 14, 6, 8, 20), "")
10 Replies
Updated file.
Sorry for attaching the wrong one.
I this better?
=UNIQUE(FILTER('OB Summary'!B:B, ISNUMBER(SEARCH("DONALDSON", 'OB Summary'!L:L))))
- That'll pick up the Donaldson, but I'd like to grab every Customer in that list.
Rodney2485 Not sure what you haven mind. The "OB Summary" sheet is empty in the file you attached.
