Hello, I currently have a table of data that I filter through. The variables use to filter include manufacturer, tonnage and type. These can all be listed as "All" or only some, or they can all be specified. However, in my tonnage drop down list I only have a specific tonnage. IE 2,3,4,5.... I would like to add in the drop down list "Range" and then I have another drop down list area that I will specify a min and max tonnage value.
Here is a snap of my search sheet.
And here is the formula I use (Thanks Fluff):
=LET(Rws,SEQUENCE(ROWS(Tab!C3:C702),,,0),FILTER(Tab!F3:Z702,(IF(B9="All",Rws,Tab!D3:D702=B$9))*(IF(C9="All",Rws,Tab!C3:C702=C$9))*(IF(D9="All",Rws,Tab!E3:E702=D$9))))
Here is some more context for cell data:
and the sheet that Im using to provide the data:
Here is a snap of my search sheet.
And here is the formula I use (Thanks Fluff):
=LET(Rws,SEQUENCE(ROWS(Tab!C3:C702),,,0),FILTER(Tab!F3:Z702,(IF(B9="All",Rws,Tab!D3:D702=B$9))*(IF(C9="All",Rws,Tab!C3:C702=C$9))*(IF(D9="All",Rws,Tab!E3:E702=D$9))))
Here is some more context for cell data:
and the sheet that Im using to provide the data: