11 STEPS
1. The Filter Function is a powerful way to filter specific data from a large data set. Open your Google Sheet select the cell in which you would like to place the filter. In this case, we want to find out which students are vegetarian.
2. Click Insert
3. With your mouse, click Function
4. With your mouse, click FILTER
5. The function is now in my cell. The Filter function now needs to know what data it will be filtering. In this case, that will be cells D2 thorough F20 Click highlight
6. With my data set now included in the Function, I know need to tell it what to filter based on. I will put a comma in the Function at right and filter based on the text in Column F.
7. Click and highlight all the cells you want to filter based on.
8. My filter function now has a range of data to filter (D2:F:20) AND the column to filter it all (F2:F20). Now we need to tell it what F2 - F:20 needs to contain in order to be pulled from our range of data.
9. In my Filter function, you can now see that F22 - F:20 needs to contain the text "Vegetarian" in order to be Filtered from our range. (HINT - You must put parentheses around text based filters in order for them to work).
10. Hit enter and we have now filtered which students are vegetarians.
11. That's it. You're done.
