How to exclude values in one list from another in Excel?

preview_player
Показать описание
Supposing you have two data lists as the left screenshot shown. Now you need to remove or exclude names in column A if the name existing in column D. How to achieve it? And what if the two lists locate in two different worksheets? This vedio provides two methods to help you solve the problem.
You can follow the step-by-step guide via the following hyperlink:
Рекомендации по теме
welcome to shbcf.ru