+ Reply to Thread
Results 1 to 12 of 12

Counting names in the cell

  1. #1
    Registered User
    Join Date
    08-29-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2003
    Posts
    303

    Counting names in the cell

    Counting names in the cell, including Compound name in the Arabic language
    Compound Name:
    - Is the name that starts ( Abd, Abu, Ben, ....)
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Counting names in the cell

    I don't see how this is possible, unless there is a rule, that excel can interpret, which tells it that a name is Arabic... It may be a coincidence that the first name is 3 letters long, but there areplenty of "western" names that have three letters (Ian, Sam, Jon, etc).
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    08-29-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2003
    Posts
    303

    Re: Counting names in the cell

    Unfortunately, Compound name in Arabic is preceded by the name "Abu, Abd, Ben."
    The name that comes after it becomes part of it, is both one name

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Counting names in the cell

    see the attached file
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  5. #5
    Registered User
    Join Date
    08-29-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2003
    Posts
    303

    Re: Counting names in the cell

    Genius solution
    This is exactly who I want
    Thank you Mr "nflsales"

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Counting names in the cell

    A little knowledge of Arabian names clearly helps!

  7. #7
    Registered User
    Join Date
    08-29-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2003
    Posts
    303

    Re: Counting names in the cell

    These are some examples of compound names
    Abd ElAlrjmn
    Abd ElJalil
    Om Ali
    Ben Gasser
    Abu Allam
    Bu aziza
    Jalal Elddin
    Izz alDin

  8. #8
    Registered User
    Join Date
    08-29-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2003
    Posts
    303

    Re: Counting names in the cell

    Why Mr "nflsales" when repeat the name Compound is given in error count
    Such as:
    Abd elChrist Peter Charles Abd elChrist
    Give me the number "5"
    With the correct number "4"

  9. #9
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Counting names in the cell

    see the attached file
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    08-29-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2003
    Posts
    303

    Re: Counting names in the cell

    Yes you did it
    Now the formula works like a charm.
    Thank you very much, Mr. "Siva"
    You are a very nice man

  11. #11
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Counting names in the cell

    Thank you Shimaa
    Glad to help you

  12. #12
    Registered User
    Join Date
    08-29-2014
    Location
    Abu Dhabi
    MS-Off Ver
    2003
    Posts
    303

    Re: Counting names in the cell

    I am very sorry mister "Siva"
    Can be converted to " UDF" formula
    Thank you again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help! Counting First and Last Names
    By Carolyn Phillips in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 04-14-2014, 02:22 PM
  2. [SOLVED] Counting names in a column but counting duplicate names once
    By TBoe in forum Excel General
    Replies: 10
    Last Post: 01-04-2014, 12:12 AM
  3. Counting up names
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 03-19-2012, 04:18 AM
  4. Counting Names
    By snoopdilla in forum Excel General
    Replies: 7
    Last Post: 03-11-2011, 01:41 PM
  5. Counting names within a cell
    By tackit in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 10-19-2010, 04:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1