Page 1 of 2 1 2 LastLast
Results 1 to 10 of 16

Thread: Count specific characters present in a column

  1. #1

    Count specific characters present in a column



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi
    I've tried doing this using formulas, but I have about 12000 entries and they aren't working as I want them to anyway. I have land transactions between multiple parties, there are transactions with a single seller and buyer, and with multiple joint owner sellers and joint owner buyers with many permutation (please see attached sheet). I want to find how many are female /male /male&female(in case of joint titles).

    The names are not in english but I have some identifying characters which can be used to determine female persons:
    मती,
    दवी,
    व ता

    There can be 1,2 or all three characters in the same name.


    The formulas I've tried and failed to use are:
    So I've tried:
    =IF(OR(ISNUMBER(SEARCH("ीमती",C3)),ISNUMBER(SEARCH("दवी",C3)),ISNUMBER(SEARCH("वती",C3))),"1","")

    But this will only determine the gender for one cell and wont 'count' if there is more than one seller/buyer

    =COUNTIF(C5:C8,"*" & "ीमती" & "*") + COUNTIF(C5:C8,"*" & "दवी" & "*")
    Again, this counts the number of instances these characters appear, however if they appear twice in the same name then it'll count it twice.

    The main problem I have is that I want the code to also look at the transaction ID to start a new count when the ID changes, so I have a count for each transaction, this is proving to be difficult because as I mentioned earlier, its not just two rows with one being a buyer and one being a seller, sometimes with joint titles there are like 5 buyers and 2 sellers and many other permutations.
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Please post links to your threads in other forums.

    Crossposting without links is against most forum rules.


  3. #3
    I'm sorry I'm new here. What do you mean exactly? What is crossposting?

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016


  5. #5
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,356
    Articles
    0
    Excel Version
    365
    I have a suggestion involving Pivot tables but I'm not sure I'm allowed to post it until you have complied with a moderator request (msg#2)

  6. #6
    Hi, I've been trying to post a link but it says I need to have 5 posts before I can include a link in my posts. Any idea how I can do this?

  7. #7
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,356
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by paladin7 View Post
    Hi, I've been trying to post a link but it says I need to have 5 posts before I can include a link in my posts. Any idea how I can do this?
    Well you could either try to disguise the link, eg:
    www dot excelguru.ca/forums/showthread.php?3010-Count-specific-characters-present-in-a-column&p=12916#post12916
    and explain what to replace, or post a couple more short messages in this thread to get you post count up (I hope this isn't against the rules!).

  8. #8
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Ok here is where I found another post:

    http://www.ozgrid.com/forum/showthread.php?t=188278

    p45cal,

    You can proceed to post your solution. Thank you.


  9. #9
    Other than just posting a couple more times

  10. #10
    Which I have done so now

Page 1 of 2 1 2 LastLast

Posting Permissions

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