Excel Formula Challenge: missing alphabets

preview_player
Показать описание
missing alphabets excel: this video demonstrates a formula to extract a list of alphabets that do not show up in a column. this uses 2 approaches
1. Using the Search function
2. Using the Countif function

00:00 Introduction
00:20 Problem description
00:50 Solution using SEARCH+FILTER
04:02 Using COUNTIF+FILTER

Link to Excel Workbook:
Рекомендации по теме
Комментарии
Автор

Very claired and very easy to understand. Great video Victor!

oscarmendez-roca
Автор

The first method seems more orthodox to me. In any case, both methods are excellent in their resolution. Thank you very much Victor.

IvanCortinas_ES
Автор

how would you use this to find special characters in the names

abibeniam