Forum Discussion

Brass Contributor

Apr 02, 2025

Solved

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...

Book1.xlsx13 KB

excel

Formulas and Functions

office 365

HansVogelaar
Apr 02, 2025
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.

Rodney2485

Brass Contributor

Apr 03, 2025

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))

HansVogelaar

MVP

Apr 03, 2025

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))

Rodney2485
Brass Contributor
Apr 03, 2025
Is there a way to use this to filter out specific Ship Via's as well?
For example, I want to only show FDXG and UPSG shipping today.
- HansVogelaar
  MVP
  Apr 03, 2025
  Yes:
  
  =UNIQUE(CHOOSECOLS(FILTER('OB Summary Update'!A2:Z5000,('OB Summary Update'!I2:I5000=TODAY())*('OB Summary Update'!J2:J5000="FORD")*(('OB Summary Update'!E2:E5000="FDXG")+('OB Summary Update'!E2:E5000="UPSG"))),1, 2,3,4,5,7,9,12,14,15,24,23))
  - Rodney2485
    Brass Contributor
    Apr 04, 2025
    You've been a phenomenal help.
Rodney2485
Brass Contributor
Apr 03, 2025
I'm going to blame not seeing that on not having my coffee this morning.

Thank you!