I have a huge Excel file with over 60 k lines and 20 columns (A:T).
I strive to delete all match numbers where column T (“2.Flag”) is “Y”.
But it is very important that the same match numbers in other lines are also deleted.
Finally the output has to be all columns.
How can I solve this issue?
Many thanks in advance!