Feb 17 2022 01:40 PM
I am attempting to build a table using Option/Radio buttons. I have built one table successfully, however I cannot get this FILTER formula to pull the correct data from my Master Table. Although I do not get an error, the formula just produced 0's where there should definitely be data. I used identical formulas and referencing to build a working FILTER formula so any suggestions as to the cause of this is appreciated.
Feb 17 2022 01:59 PM
=FILTER(BT3:BW55;BT2:BW2=ERSTERWERT(CB1;1;"Trailer Shipments";2;"TB Shipments";3;"Trailer Production";4;"TB Production"))
This formula seems to be the german translation of your formula and works well in my spreadsheet.
Feb 17 2022 05:11 PM