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

ovelzone

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.

Brent Wilson

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 Wilson

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)

ovelzone

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