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:

Screenshot of my sheet

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.

migrated from superuser.com Dec 20 '17 at 15:04

This question came from our site for computer enthusiasts and power users.


A similar question to this was posted on Stack Overflow.

Try this:



Also a useful extension to ale's formula would be incorporating it into multiple lists using ";".


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy