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...
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), "")
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.
So you want to copy the OB Summary data to Sheet1? Copy/Paste should do that.
