You are reading a single comment by @aggi and its replies. Click here to read the full conversation.
  • 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?

  • 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.)


    1 Attachment

    • Screenshot 2023-12-05 162006.jpg
About

Avatar for aggi @aggi started