Extract names in a list, and present in order, based on qty criteria.

Hi,

Explanations are also found in the spreadsheet.


In a table I have several modes, with items and various quantities.
When I choose a mode in a dropdown, then I want to present the relevant items for that mode, if they have a qty attached to it.

Please no volatile functions or VBA.


Hope you can help.

Best regards,

Trond Grimstad