Hello all! I have a spreadsheet of about 3000 rows and columns A to EQ. What I'd like to do is cut all duplicate rows and put them on a new sheet, so that both the original and duplicate (or triplicate) are part of a new sheet. Also, getting rid of any empty rows left behind by those that are cut. I have Conditional Formatting picking up duplicates in columns E, F, H, N, O, P, and Q. Is there a way to do this?