4-Participant

Solved

Filter data using comboboxes

Hi!

Is there a way to make a filter based on comboboxes ? i.e.

I want to be able to filter "Type" and "Version" so that the end result is a matrix i can plot

I used vlookup to easily filter "Type", but not sure how i can incoorporate the "Version" filter?

(I've attached my sheet, MCP 9)

Thank you!

Regards
SNA

Best answer by Werner_E

It looks to me that you are looking for a n x2 matrix as the result of the filtering!?

You may write a filter function like the one shown below

BTW, you had a typo in the version "A" in the first data row, there was an extra "

Answer

25-Diamond I

It looks to me that you are looking for a n x2 matrix as the result of the filtering!?

You may write a filter function like the one shown below

BTW, you had a typo in the version "A" in the first data row, there was an extra "

25-Diamond I

Here is a different approach, a tricky one-liner

You may use try & catch for some error trapping

Author

4-Participant

Hi @Werner_E

Thank you so much!

Your first suggestion worked perfectly on a bigger data set i have 😁 Although i must confess i do not quite understand what is happening here:

I will also try your one-liner 🙂

Regards
SNA

Sign up