I would like to filter Excel rows by two parameters using Dynamo. For example:
I need those rows, where two conditions (Anna & Active) will be fulfilled.
I don’t need these rows (Max & Active), because here is Max, not Anna
And I don’t need these rows (Anna & Approved), because here is Approved, not Active.
I can’t edit Excel file, it should be done with Dynamo, because it should be possible to change the conditions if needed.
For now, I have this Code:
But I don’t know how to filter the list with other two lists… List Create didn’t help, because this node just combine first two list in a huge one.
Maybe there is a Python code for that?
Thank you very much in advance!