Explanation
This formula relies on the FILTER function to retrieve data based on alogical test.
Thearrayargumentis provided as B5:D15, which contains all of the data without headers.
If the two strings are exactly the same, EXACT returns TRUE.
If the two strings are not exactly the same, EXACT returns FALSE.
This array returned directly to the FILTER function as theincludeargument.
Rows where the color is “Red” are not included.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
SEARCH returns the position offind_textinsidewithin_textas a number.
