How to filter bad data and duplicates?

Hi I tried using the excel remove duplicates but got a can't change array message and I'm not sure that's the answer I'm looking for.

Is there a filter expression I can add to ignore/remove the items in yellow being "bad" and then the data point after at 07:48 is also a duplicate of the good value from 07:36? Thanks

 


image.png
 


image_1.png