MS Excel / VBA help thread

You are reading a single comment by @aggi and its replies. Click here to read the full conversation.

•

rhb

I need to filter on either of 2 items of many in a column to give a cleaner view auto filter isn't an option as it is a shared workbook with multi users so I'm creating a mirror worksheet elsewhere to give the clean view.

My solution was to have the 2 items as lookup cells, then create a data validation picker to choose either option, then point the Filter function to use that cell to define what to filter by.

This works at first, then when I change the data validation picker the results don't change.

I can't see why. Is there something really simple I've overlooked (calculation option is automatic)?

•

aggi in reply to @rhb
I've just tested this on a set of test data I had open and it works fine for me on O365 (I assume you must be on a pretty up-to-date version if you have the FILTER formula). Updates automatically when I change the dropdown.

1 Attachment
- Filter test.xlsx

•

rhb in reply to @aggi

It worked here until I shared the file with a colleague... might that be causing the problem?

Thanks for testing and confirming it should work in principle too.

About

@aggi started