Hi, Is there a way to count and display in another column of how many repeated names?
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.
Help Article Resources
Check out the Formula Handbook template!