Hello,
i need to do one project for a university, and i can't get the formula right...hope somebody can help me out, would appreciate that alot!
situation is this. I have two text articles and have all their words put to column a with a count of how many times each word appears in all article (see attachmen), columns A and B.
Then respectively in columns GH and IJ there are words from each article and number, how many times each word appears in article.
I need to come up with a formula, to get numbers in indicated in red (in the attachment) which checks if the word on column A exists in Article 1 and if yes, how many times.
Appreciate your help!!
Bookmarks