Search code examples
google-sheetsformulas

How to remove an item from a list

I've got a list of text strings created from (listA and listB are named ranges):

=UNIQUE({listA;listB})

How would I need to change this formula to exclude the value "XXX", if it were to show up?

Solution

  • Use 

    =FILTER(UNIQUE({listA;listB}),UNIQUE({listA;listB}) <>"XXX")