Forum Discussion
r2-Molin
Jun 29, 2023Copper Contributor
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...
- Jun 29, 2023
Detlef_Lewin
Jun 29, 2023Silver Contributor
There is really only ONE filter criteria. And there are only 4 rows which comply with the filter.
Just filter the blue table.
But I also included a PQ- and a formula solution.
- r2-MolinJun 29, 2023Copper ContributorAh I see, then is there some way then I could also extract the "Tx" values associated with each of the "RFU" values as well?
- Detlef_LewinJun 29, 2023Silver Contributor
- r2-MolinJun 30, 2023Copper ContributorMany thanks!