troubleshooting Question

Excluding specific cell values (names) from a list

Avatar of Doug Van
Doug VanFlag for Canada asked on
Microsoft OfficeMicrosoft ExcelSpreadsheetsGoogle Apps* Google Suite
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):
https://docs.google.com/spreadsheets/d/1AMo4K0H8cijjb_88Y8rJ54cObzQ0SRhoR97q1i5Q1jE/edit#gid=964764875


Thank you. :)
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
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