[Solved] Multiple AND OR Conditions Filter

[GimpyHand]

I have a table that I need to filter with multiple conditions. I need it to display all results based on which conditions are selected.

Some of the conditions may not be selected and I need the results from the conditions selected, omitting the blank conditions. Here's the data:

Table - 'Table'!A2:M1048576

Division - 'Table'!A2:A1048576
Supplier - 'Table'!B2:B1048576
PO # - 'Table'!D2: D1048576
Part # - 'Table'!F2:F1048576
Date - 'Table'!C2:C1048576

Report Sheet with conditions and where the filtered table is (Report)

Division Condition - B6
Supplier Condition - B7
PO # Condition - B8
Part # Condition - B9
Date Start Condition - B4
Date Start Condition - B5

 

[Lutfor Rahman Shimanto]

I have a table that I need to filter with multiple conditions. I need it to display all results based on which conditions are selected.

Some of the conditions may not be selected and I need the results from the conditions selected, omitting the blank conditions. Here's the data:

Table - 'Table'!A2:M1048576

Division - 'Table'!A2:A1048576
Supplier - 'Table'!B2:B1048576
PO # - 'Table'!D2: D1048576
Part # - 'Table'!F2:F1048576
Date - 'Table'!C2:C1048576

Report Sheet with conditions and where the filtered table is (Report)

Division Condition - B6
Supplier Condition - B7
PO # Condition - B8
Part # Condition - B9
Date Start Condition - B4
Date Start Condition - B5

Hello GimpyHand

Welcome to ExcelDemy Forum! Thanks for reaching out and sharing your problem. You are trying to filter a table in Excel based on specific criteria. We have demonstrated your situation and fulfilled your goal using the Excel FILTER function.

SOLUTION Overview:

=FILTER(Table!A2:M1048576, (Table!A2:A1048576=Report!B6) * (Table!B2:B1048576=Report!B7) * (Table!D2:D1048576=Report!B8) * (Table!F2:F1048576=Report!B9) * (Table!C2:C1048576>=Report!B2) * (Table!C2:C1048576<=Report!B3))

​

I have attached the solution workbook for better understanding; good luck.

Regards
Lutfor Rahman Shimanto
ExcelDemy