Unique() filter to exclude blanks and multiple strings

[metcala]

Hi all

Sorry this is probably a simple question but just can't seem to get it working.

I have a column A with values: A, B, C, D, E, F, , G, H

I am looking to extract a unique list that excludes blanks and B and C - i.e. A, D, E, F, G, H

I have started with =UNIQUE(FILTER(A:A, A:A<>"")) but wasn't sure how to also exclude B and C too.

Any help would be much appreciated!

 

[hagia_sofia]

Hello, you might wanna select a specific range instead of the whole column:

=UNIQUE(FILTER(A1:A20,(A1:A20<>"")*(A1:A20<>"B")*(A1:A20<>"C")))

 

[metcala]

Hello, you might wanna select a specific range instead of the whole column:

=UNIQUE(FILTER(A1:A20,(A1:A20<>"")*(A1:A20<>"B")*(A1:A20<>"C")))

Thanks so much! That's perfect!