Forum Discussion

Johnnyg3742's avatar
Johnnyg3742
Copper Contributor
Apr 12, 2019

Printing just duplicate data

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 high...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 12, 2019

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

and print - only filtered rows will be printed

  • Johnnyg3742's avatar
    Johnnyg3742
    Copper Contributor
    Apr 12, 2019

    SergeiBaklan 

     

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