Clay Icon

Adding a Column to Count Duplicate Names in a List

Β·
Β·

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?

  • Avatar of Guy M.
    Guy M.
    Β·
    Β·

    Is this a valid solution?

  • Avatar of Guy M.
    Guy M.
    Β·
    Β·

    I think it works, but I want to compare only using lowercase, ignore cases . How can I do that?

  • Avatar of Clay Team
    Clay Team
    APP
    Β·
    Β·

    Hi Guy M., happy to help!

  • Avatar of Clay Team
    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)?

  • Avatar of Guy M.
    Guy M.
    Β·
    Β·

    Yes, but I think I managed this