Count specific characters present in a column

**paladin7** · 2014-05-12, 09:52 AM

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.

**NBVC** · 2014-05-12, 01:19 PM

Please post links to your threads in other forums.

Crossposting without links is against most forum rules.

**paladin7** · 2014-05-12, 02:19 PM

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

**NBVC** · 2014-05-12, 02:57 PM

Have a read here: http://www.excelguru.ca/content.php?184

**p45cal** · 2014-05-12, 03:46 PM

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)

**paladin7** · 2014-05-12, 03:58 PM

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?

**p45cal** · 2014-05-12, 04:19 PM

Originally Posted by paladin7

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

**NBVC** · 2014-05-12, 04:20 PM

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.