Formula to filter?

alexis.bratton

Sheet w/ Source Data:

SS1.PNG

Goal: New sheet w/ just data for Fruit w/o using a Report and updates in real-time

SS2.PNG

Hollie Green

Few questions:

Are you pulling in the count of each fruit? or just numbering them?

Will the types of fruit change or always be consistent? and if they do change is it to often to update a row on your new sheet to match the types of fruit?