How to use the FILTER function to display students who scored 91 or higher EN – Here’s what’s happening: On the left, there’s a table labeled “Students” with two columns: Name (column B) Score (column C) The formula in cell E6 is: =FILTER(B6:B12, C6:C12 >= 91, “No results”) This formula filters the list of student names (B6:B12) and returns only those whose scores (C6:C12) are greater than or equal to 91. If no students meet that condition, it shows “No results” instead. The filtered results — Anna, Maria, and Bill — appear in column E. The text box on the right explains the filter formula and shows its syntax. The highlighted cell (E6) contains the first filtered result, “Anna”. Essentially, the image shows how to use the FILTER function in Excel to extract specific rows that meet a given condition. Download the excel file: filter_function.xlsx *Important This is the right…
