Hi, Is there a way to count and display in another column of how many repeated names?

Hi,

I am totally new to smartsheet, working on small work projects and learning at the same time. Hope some one here can help or advise on a query i got stuck with? Is there a formula or a way to count how many times a name is repeated in Column1 (below example table) and to display the names in Column12 and the total repeated number in Column13? Just wondering is this possible? if so what formula to use? i would really appreciate any help or advise on this.

Many thanks in advance.

Best Answer

  • Brent Wilson
    Brent Wilson ✭✭✭✭✭
    Answer ✓

    The COUNTIF function is all you need to be placed in Column 13

    =COUNTIF([Column1 Staff names]:[Column1 Staff names], [Column 12 Staff names]@row)

    If you place this formula in the blank column it would show you how many times that name appears without having to type the name yourself

    =COUNTIF([Column1 Staff names]:[Column1 Staff names], [Column1 Staff names]@row)

    Brent C. Wilson, P.Eng, PMP, Prince2

    Facilityy Professional Services Inc.

    http://www.facilityy.com

Answers

  • Brent Wilson
    Brent Wilson ✭✭✭✭✭
    Answer ✓

    The COUNTIF function is all you need to be placed in Column 13

    =COUNTIF([Column1 Staff names]:[Column1 Staff names], [Column 12 Staff names]@row)

    If you place this formula in the blank column it would show you how many times that name appears without having to type the name yourself

    =COUNTIF([Column1 Staff names]:[Column1 Staff names], [Column1 Staff names]@row)

    Brent C. Wilson, P.Eng, PMP, Prince2

    Facilityy Professional Services Inc.

    http://www.facilityy.com

  • Brent C. Wilson, Thank you so much, appreciate it. All working good.🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!