Filter Excel Data in dynamo based on cell value

[fkp7057]

Hello All Dynamo Experts,

I am currently working on a project where I need to import Excel data into Dynamo. The Excel sheet contains information as illustrated in the attached image.

My specific requirement is to import only the rows where the value in column D is “No.” Alternatively, if there is a way to filter out rows with “Yes” in column D after importing into Dynamo, that would also meet my needs.

I’m seeking advice on the best approach or nodes to achieve this in Dynamo. Any guidance, sample scripts, or suggestions on how to handle this scenario would be greatly appreciated.

For a clearer understanding of my requirements, please refer to the images attached below:

Thank you in advance for your valuable assistance!.

FKP

[Draxl_Andreas]

@fkp7057 ,

if you can it manage in excel, you can do it this way

KR

Andreas

[Mark.Ackerley]

A slightly different way, just for variety

[fkp7057]

Big thanks to the both of you @Draxl_Andreas and @Mark.Ackerley for the swift and helpful responses! Implemented the solution and it worked like a charm.