When the state in H4 is changed, the formula should return a new set of records.
FILTER function
TheFILTER function"filters" a range of data based on supplied criteria.
The result is anarrayof matching values from the original data.
you’re able to customize this message as you like.
Supply an empty string ("") to display nothing.
If you omitif_emptyaltogether, FILTER will return a #CALC!
error when no data is returned.
When the formula above is entered, theincludeargument is evaluated.
This array is used by the FILTER function to retrieve matching data.
Only rows where the result is TRUE make it into the final output.
Other fields and criteria
Other fields can be filtered in a similar way.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
