Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Adding a Column to Count Duplicate Names in a List | Clay

Adding a Column to Count Duplicate Names in a List

·Feb 21, 2024 09:50 PM·

I have a list of people, sometimes with the same names. Is it possible to add a coloumn that indicates how many times this name appears in the entire table?

5 comments

· Sorted by Oldest

Guy M.
·
·
Is this a valid solution?
Loading attachments
Guy M.
·
·
I think it works, but I want to compare only using lowercase, ignore cases . How can I do that?
Clay Team
APP
·
·
Hi Guy M., happy to help!
Clay Team
APP
·
·
Just to clarify - do you want matches to be found regardless of when you use upper case and lower case (as long as the names themselves match)?
Guy M.
·
·
Yes, but I think I managed this