Printing just duplicate data

Copper Contributor

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?

 

Thanks

3 Replies

@Johnnyg3742 , if you highlight duplicates you may filter by this color

image.png

and print - only filtered rows will be printed

@Sergei Baklan 

 

Thank you so much, that has saved me so much time, I appreciate it.

@Johnnyg3742 , you are welcome