I have a table, A and B. In another sheet I'd like to have a selector, presumably using a list formatted cell, which would then display the results.
A simple lookup will only return the first instance of B.
How?
1 Attachment
I'd use a pivot table and a slicer.
FILTER formula is nice and neat for this stuff. (Personally I prefer formula driven stuff to clicking boxes in slicers but each to their own.)
@moocher started
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.
I have a table, A and B. In another sheet I'd like to have a selector, presumably using a list formatted cell, which would then display the results.
A simple lookup will only return the first instance of B.
How?
1 Attachment