[Solved] Multiple AND OR Conditions Filter

GimpyHand

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

Output of filtering table in Excel based on specific criteria.gif

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

Regards
Lutfor Rahman Shimanto
ExcelDemy
 

Online statistics

Members online
0
Guests online
10
Total visitors
10

Forum statistics

Threads
311
Messages
1,378
Members
568
Latest member
WilliamHon
Top