I am working on a Google Sheets that has a phrase, assigned number to the phrase and then I want to create a new list on a new column of phrases that have an assigned number less than
5. Moreover, I do not want phrases repeated:
Currently I have this as my formula in cell E4:
and it is not working.
Could anyone help me to get this right?
I have access to Excel so that would work too.