You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Chalfie
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)?