Return Missing Values From List
Budget: $30 – $250 USD
I need an excel formula (not vba) that compares a sentence to a list of words, then returns all words in the sentence not contained in the list of words. Formula should be dynamic. If the list of words is updated, the column of missing values should update as well.
Excel file contains...
List Of Words
-------------
love
hate
pandas
monkeys
-------------
Sentences
-------------
I love pandas
I hate monkeys
pandas pandas pandas
monkeys monkeys
-------------
Expected Results
Sentences - Missing
--------------------------------------------
I love pandas - I
I hate monkeys - I
pandas pandas pandas -
monkeys monkeys -
--------------------------------------------
Excel file contains...
List Of Words
-------------
love
hate
pandas
monkeys
-------------
Sentences
-------------
I love pandas
I hate monkeys
pandas pandas pandas
monkeys monkeys
-------------
Expected Results
Sentences - Missing
--------------------------------------------
I love pandas - I
I hate monkeys - I
pandas pandas pandas -
monkeys monkeys -
--------------------------------------------