Avatar of Doug Van
Doug Van
Flag for Canada

asked on 

Excluding specific cell values (names) from a list

Hello Experts,

In the following sheet (Google Sheet - but the solution is likely the same for Excel), I am sorting a list of unique names (column H) that are extracted from 3 columns (B, N, and P).

But I'd like to have the ability to exclude specific names that are listed in column (J), the exclude list. How can I accomplish that?

Please see the tab (Auto-populate from list):

Thank you. :)
* Google SuiteSpreadsheets* google spreadsheetsGoogle WorkspaceMicrosoft Excel

Avatar of undefined
Last Comment
Tom Farrar

8/22/2022 - Mon