# Thread: Count specific characters present in a column

1. ## Count specific characters present in a column

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.

Crossposting without links is against most forum rules.

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

4. 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)

5. 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?

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:
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!).

7. Ok here is where I found another post:

p45cal,

You can proceed to post your solution. Thank you.

8. Other than just posting a couple more times

9. Which I have done so now

Page 1 of 2 1 2 Last

#### Posting Permissions

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