Please post links to your threads in other forums.
Crossposting without links is against most forum rules.
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.
Please post links to your threads in other forums.
Crossposting without links is against most forum rules.
I'm sorry I'm new here. What do you mean exactly? What is crossposting?
Have a read here: http://www.excelguru.ca/content.php?184
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)
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!).
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.
Other than just posting a couple more times
Which I have done so now
Bookmarks