Forum Discussion
Johnnyg3742
Apr 12, 2019Copper Contributor
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 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
- SergeiBaklanDiamond Contributor
Johnnyg3742 , if you highlight duplicates you may filter by this color
and print - only filtered rows will be printed
- Johnnyg3742Copper Contributor
- SergeiBaklanDiamond Contributor
Johnnyg3742 , you are welcome