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