How to filter duplicate values in column A and filter out rows which have column C blank.
I have 2200 rows in Col A (the first 1400 rows also have data in Col B & C, the next 800 rows are duplicates of the first 1400 rows, but don't have data in Col B or C).
I want to only keep the 800 duplicate rows, but keep the one which has data in Col B & C, and remove the row which is has a blank value in Col B & C.