Hello and thanks in advance for the help!
I'm using the formula below and it works just fine. But now I need to include an OR statement with the "type" and I'm not sure how. I've tried using a + and adding it but I get an error. The type is either "XPDARTM" or "JNL" but can't figure out how to add it. And I'm using named ranges, in case you wonder what type or eltwo or include are.
I'm using the formula below and it works just fine. But now I need to include an OR statement with the "type" and I'm not sure how. I've tried using a + and adding it but I get an error. The type is either "XPDARTM" or "JNL" but can't figure out how to add it. And I'm using named ranges, in case you wonder what type or eltwo or include are.
=IFERROR(FILTER(eltwo,(Include=1)*(type="xpdartm"))," ") |