Hide rows with duplicate values
Hello,
I have a spreadsheet where the primary column has cell entries where there are duplicate names, which are intentional to show variations. How do I show the primary column where duplicate names are hidden?
Thanks,
Amy
Answers
-
I have never seen a way to hide rows, only columns. The only way to "hide" them would be to remove them, but that would mean losing data and that wouldn't be good. If you could have the variations fall into a different column, then you could hide them like that.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
How can I automatically remove the duplicate rows? Is there a way to do this with a formula and not manual?
Thanks,
Amy
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!