Forum Discussion
Filter with Multiple Criteria
I'm trying to filter out data with specific criteria and cant seem to get it all into one single formula.
I need to Filter all Delivery #'s based of today's date and specific Make
This is what I've got so far, but am unable to get the date criteria incorporated correctly.
=UNIQUE(FILTER('OB Summary Update'!B:B,('OB Summary Update'!B:B<>"")*('OB Summary Update'!J:J="FORD")))
Do you want to filter on Start Ship Date (column I) being today? If so:
=UNIQUE(CHOOSECOLS(FILTER('OB Summary Update'!A2:J1000,('OB Summary Update'!I2:I1000=TODAY())*('OB Summary Update'!J2:J1000="FORD")), 2, 10))
The result will spill to 2 columns and as many rows as needed.
7 Replies
Do you want to filter on Start Ship Date (column I) being today? If so:
=UNIQUE(CHOOSECOLS(FILTER('OB Summary Update'!A2:J1000,('OB Summary Update'!I2:I1000=TODAY())*('OB Summary Update'!J2:J1000="FORD")), 2, 10))
The result will spill to 2 columns and as many rows as needed.
This mostly works; however I want the following columns to populate "1,2,3,4,5,7,9,12,14,15,24,23" seems like once I go pass column 9, I get a #value error
=UNIQUE(CHOOSECOLS(FILTER('OB Summary Update'!A2:J5000,('OB Summary Update'!I2:I5000=TODAY())*('OB Summary Update'!J2:J5000="FORD")),1, 2,3,4,5,7,9,12,14,15,24,23))
Add more columns to the range to be filtered:
=UNIQUE(CHOOSECOLS(FILTER('OB Summary Update'!A2:Z5000,('OB Summary Update'!I2:I5000=TODAY())*('OB Summary Update'!J2:J5000="FORD")),1, 2,3,4,5,7,9,12,14,15,24,23))
