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.


A similar question to this was posted on Stack Overflow.

Try this:


| improve this answer | |

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

| improve this answer | |

Your Answer

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