I have a worksheet with over 3.5k rows of data, no two values of a specific column should be the same, however approx 150 rows of this column is duplicated.
I have conditionally formatted to highlight the duplicated rows, my question is this,
Is there a way to print just these specific rows or even just the specific data?
@Johnnyg3742 , if you highlight duplicates you may filter by this color
and print - only filtered rows will be printed
Thank you so much, that has saved me so much time, I appreciate it.
@Johnnyg3742 , you are welcome