Hi,
I have used these boards for a while to look for solutions to problems so thank you to everyone who has contributed previously as you have probably helped me before. this is my first post for specific support as I cannot find the answer I'm looking for so maybe I'm looking for the wrong formula.
I have a database of words related to a topic, for instance B1 is relationship and under is a list of words which correspond, for example "brother, brothers, mother, mothers, father, fathers, sister, sisters" etc.
In cell A1 I have a statement which says "I have two sisters, five bothers and a mother"
I would like a formula to count how many words from my relationship range feature in cell a1. I don't need a breakdown of each word, just a sum of relevant words (so in this case I would like the value to return "3".
I have looked to use LEN(Substitute) formula but don't wish to have to write it for each word in my list, I want it to use the range but I cant get it to work.
I hope I haven't worded this in a complicated way and thank you for any help you can give me on this.
Regards,
Kev.
Bookmarks