Delete rows from workbook if 2 columns contains "Y"

dtinput.AsEnumerable().Where(Function(row) row.Field(Of String)(“Tax Has Employee Tax”) <> (“Y”) AndAlso row.Field(Of String)(“Tax Has Employer Tax”) <> (“Y”)).CopyToDataTable()

Can you try query it will remove the Y rows completely in the both columns

@ayushi_jain3

1 Like