Hello
I'm stuck on the problem below.
I have a dataset that I would like to categorise and filter. In this process I want to (1) remove cells that are not unique, (2) remove cells that contain a specific word from a list, and (3) keep one of those uniques, even though it contains a word from said list.
The idea is, that I will be able to lable entries, ex. "She eats Orange" with "Orange", and an entry like "She eats Orange 12345" wont show up.
If I get new raw data (ex. "The grass is green" and "The grass is green 1234", both should show up, until I label one ex. "Green".
The attached excel document is an attempt to show the desired result.
Thanks
Jonas / Jazzzz
Bookmarks