👋 Welcome! Introduce yourself and connect with your peers in Education to receive your industry badge.

Count multiple names in one cell without knowing new entry

Govinda
Govinda ✭
in Education

I have multiple names in one cell and no fixed list of names as if whose names will be there in the new entry and want to count unique names. How to do that using countif ?

· Share on FacebookShare on Twitter

Comments

  • Erin Horiuchi Green
    Erin Horiuchi Green ✭✭✭✭✭

    @Govinda Is there a screenshot example of the cell? Trying to determine if the column is Contact List or Text/Number as well as the entry format.

    Erin Horiuchi Green, MBA, LSSYB, PSMI
    Process Manager
    Syneos Health

    Please kindly like ❤️, upvote ⬆️ and/or mark ✅ any of my contributions that have provided value.

    Core App and Project Managment Certified 🚀

    · Share on FacebookShare on Twitter
  • Govinda
    Govinda ✭
    edited 11/01/24

    Hi Erin, it is Text/ Number and entry is received from a from which will be filled by other people so that they can add multiple names in the Name entry.

    · Share on FacebookShare on Twitter

Categories

Engage with peers in
Education to receive your
industry badge