As expected, the main function used in this case study is:
=FILTER(Master!A:F,Master!B:B=”Fruits”)
- We are filtering the main table on the Master sheet for the lines where, in column B, the category is Fruits.
- Only these lines will be shown on this sheet.
- We do the same for the other sheets in the document – one sheet for each of the categories we have identified for our data.