Filter a table by status with FILTER
IntermediateFILTER is useful when you want Excel to return only the rows that match a condition, such as orders with a specific status. Modern Excel formulas can return more than one cell at once, and when that happens the results spill into nearby cells automatically. FILTER is one of the most useful dynamic array functions for creating focused views from a larger table.
FILTER uses this structure:
=FILTER(array, include, [if_empty])
The array is the full range you want returned. The include argument is a logical test that produces TRUE for the rows you want to keep and FALSE for the rows you want to exclude.
In this sheet, you are preparing the pending-order follow-up list for the team. Pull only the orders whose status is Pending and return the matching rows in the output area below the table.
Your task:
Enter one FILTER formula in A12 that returns the matching pending orders from the table. Let the formula spill into the surrounding cells automatically, rather than typing anything into the rest of the output range.
Need some help?
Hint 1
To test the Status column, compare the whole status range to the text value: C2:C9="Pending". This creates TRUE for pending rows and FALSE for the others.
Hint 2
Use the full order table as the returned array, and use the status-column test as the include argument so the result spills all four fields starting in A12.
Filter a table by status with FILTER
IntermediateFILTER is useful when you want Excel to return only the rows that match a condition, such as orders with a specific status. Modern Excel formulas can return more than one cell at once, and when that happens the results spill into nearby cells automatically. FILTER is one of the most useful dynamic array functions for creating focused views from a larger table.
FILTER uses this structure:
=FILTER(array, include, [if_empty])
The array is the full range you want returned. The include argument is a logical test that produces TRUE for the rows you want to keep and FALSE for the rows you want to exclude.
In this sheet, you are preparing the pending-order follow-up list for the team. Pull only the orders whose status is Pending and return the matching rows in the output area below the table.
Your task:
Enter one FILTER formula in A12 that returns the matching pending orders from the table. Let the formula spill into the surrounding cells automatically, rather than typing anything into the rest of the output range.
Need some help?
Hint 1
To test the Status column, compare the whole status range to the text value: C2:C9="Pending". This creates TRUE for pending rows and FALSE for the others.
Hint 2
Use the full order table as the returned array, and use the status-column test as the include argument so the result spills all four fields starting in A12.