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

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!