Filter Data Dynamically With Excel

FILTER(Range1,Range2=Criteria) 

This formula is also using the FILTER function in Microsoft Excel.

1. The range 'Range1' contains the data that needs to be filtered.
2. The range 'Range2' contains the criteria to be matched.
3. The criteria is defined as 'Criteria', which means that the function will return only the values in 'Range1' that have a corresponding match in 'Range2' with the value 'Criteria'.

In simpler terms, the formula is filtering data from 'Range1' based on a condition specified by comparing it with the 'Range2' values. It will return only those values that meet the criteria specified in 'Criteria'.