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 T.
    Clay T.
    APP
    ยท
    ยท

    Hi Guy M., happy to help!

  • Avatar of Clay T.
    Clay T.
    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