How to create a list

[Hinch74]

Hello

I have a list which has various different entries in unique rows. Is it possible to create a button which when selected, would aggregate all entries into 1 view in various rows i.e. only show me entries categorised by a single factor? e.g. a most of various fruits which includes different coloured apples and other fruits. Can I create a button which would then only show me the different types of apples which were entered?

Thanks.

[RChad]

This may seem simple but might be complex. Please attach a sample file of what you want to accomplish. It will likely require VBA.

[jeffreybrown]

Hello & Welcome to the Forum,

How about just creating a pivot table? You could also link the pivot table with slicers as the button

[cwodavids]

What exactly do you want in the list? You would be better attaching your spreadsheet.

[Hinch74]

Thank you all for your prompt replies. I appreciate I didn't describe my requirement that well but I've now worked it out. Thanks again!

[jeffreybrown]

Can you share what you worked out? That way, if somebody is trying to do the same thing they can learn from what you have discovered.