<div>
Someone tried a formula using Filter, but it didn't work. Thank you though. I solved my own problem... but not an ideal solution. By making column (H) a helper column, I created a new final result column (L) with the formula: =query(H3:H50," select * where NOT H matches '"&amp;JOIN("|", J3:J22)&amp;"' ") This works! :) But if someone more clever than me can find a way to accomplish the same results without a helper column, I will be grateful! To recap, the helper column (H) combines, sorts, and lists all the unique cells in columns (B, P, R) using the formula: =Sort(UNIQUE({B3:B22;P3:P18;R3:R7}),1,true) Then column (L), compares column (H) against an exclusion list and lists out only names not included in the exclude list column (J). Thanks
</div>

<div>
Have you tried replacing H3:H50 in your new formula with the original formula? 
 
That might work, and if it does you wouldn't need the helper column but you would end up with a pretty complicated formula.
</div>

Technical Writer

Doug Van

<div>
Hi Norie, &gt; Have you tried replacing H3:H50 in your new formula with the original formula? I tried that but I couldn't make it work. :( &nbsp;I don't mind complicated formulas... they are preferred over helper columns. :) Hi Tom, &gt;Look at column G Your formula is just another way to arrive at the same results as my column L. But I like your simpler formula, even if you are still depending on column H. *BUT* Then I realized that I could embed my column H formula with your formula. Thus eliminating column H, as I requested. Yes, I am grateful! Kudos to you! So... =filter(Sort(UNIQUE({B3:B22;O3:O18;Q3:Q7}),1,true),countif(I3:I,UNIQUE({B3:B22;O3:O18;Q3:Q7}))=0) Works. 
</div>

<div>
<div class="content wysiwyg-content">
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): 
<a href="https://docs.google.com/spreadsheets/d/1AMo4K0H8cijjb_88Y8rJ54cObzQ0SRhoR97q1i5Q1jE/edit#gid=964764875" rel="ugc">https://docs.google.com/spreadsheets/d/1AMo4K0H8cijjb_88Y8rJ54cObzQ0SRhoR97q1i5Q1jE/edit#gid=964764875</a> 
 
 
Thank you. :)
</div>
</div>

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):
https://docs.google.com/spreadsheets/d/1AMo4K0H8cijjb_88Y8rJ54cObzQ0SRhoR97q1i5Q1jE/edit#gid=964764875 (https://docs.google.com/spreadsheets/d/1AMo4K0H8cijjb_88Y8rJ54cObzQ0SRhoR97q1i5Q1jE/edit#gid=964764875)


Thank you. :)

Excluding specific cell values (names) from a list

Google Suite

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

google spreadsheets

Google Workspace is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Workspace adds business-specific features such as custom email addresses at your domain and storage for documents and email.

Google Workspace

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.