Forum Discussion

r2-Molin's avatar
r2-Molin
Copper Contributor
Jun 29, 2023
Solved

Filtering based on two criteria and getting rid of #N/A values

First: I am desperately trying to sort through a database based on two columns/criteria (Tx and FLASK #) in order to return a list of all the associated values (RFU) that match those criteria. I've t...
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jun 29, 2023

    r2-Molin 

    =FILTER(CHOOSECOLS(Tabelle1,1,9),Tabelle1[FLASK '#]=Tabelle2[FLASK '#])

     

Resources