troubleshooting Question

Excluding specific cell values (names) from a list

Avatar of Doug Van
Doug VanFlag for Canada asked on
* Google SuiteSpreadsheets* google spreadsheetsGoogle WorkspaceMicrosoft Excel
5 Comments1 Solution74 ViewsLast Modified:
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. :)
Tom Farrar

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros