Forum Discussion

dm2542's avatar
dm2542
Copper Contributor
Feb 17, 2022

Filter Formula won't produce results

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.

excel
Formulas and Functions

2 Replies

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Feb 17, 2022

    dm2542 

    =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.