I populate a datatable from a scrape of a table on a web page. The data looks like the following:
I would like to remove the rows where both Score and Total are 0 and or NA. If either has a value in it greater than 0 or that is not NA, then I want to keep the row.
I tried using an IF statement in a For each row and deleting the row if the conditions of the IF were met, but the For each row does not like it when you delete a row in the For loop. This makes sense because the new total number of rows has changed and would impact the loop.
How might I achieve removing the row based on two conditions?
(Score=“0” OR Score=“NA”) AND (Total=“0” OR Total=“NA”)