Nov 01 2023 11:45 AM - edited Nov 01 2023 11:47 AM
Dear community,
I put 100 question from Word to an Excel file. And then seperate each word from an sentence into a seperate column.
My goal is to find an unique word in a sentence that is not in other sentences.
For identifying the sentence.
To find an unique word n a sentence that is not in other sentences is easy.
But what about finding 2 words combined that makes the sentence unique that is not in other sentences !
Is that possible in Excel? Who can help me?
Gr. P
Nov 01 2023 02:48 PM
Nov 01 2023 03:01 PM
For example these are 3 dutch sentences:
De word "ring" is only in sentence 1. It isn't in the other sentences. So i can identify sentence 1 by its word "ring". Is it possible to make a combination of 2 words that makes it unique to identify a sentence.
I have devide every word of each sentence in its own Excel column. Is there a way to select f.e. 2 words from a sentence and that excel shows me if they are unique?
Gr. P
Nov 01 2023 05:01 PM
Solution