Stop Using Long and Complicated Formulas : Try " " , '*' and '?' Instead / Excel
Автор: Office Freak
Загружено: 2025-12-11
Просмотров: 6057
In this video, you learn how to use the Double Quotes, Asterisk and the Question mark in Excel. This applies to many Excel formulas, including Sumifs, Countifs, VLOOKUP, XLOOKUP, INDEX-MATCH, Filter and many more. First, you learn how to use the asterisk with the Countifs function, followed by the question mark with the same Countifs. Then we'll go over the asterisk for the Find and Replace tool as well as the VLOOKUP.
You can join the Channel Membership from the Link below
/ @officefreak
File Link
https://docs.google.com/spreadsheets/...
Chapters:
0:00 - Intro
0:19 - Asterisk (*)
2:36 - Asterisk (*) & Question Mark (?)
4:09 - Asterisk (*) - Beginning - Mid - Both sides
8:06 - Question Mark (?) - One - Two - Multiple
10:22 - Creating Wildcard with Asterisk (*), &
14:07 -Asterisk (*) in Find & Replace
15:34 - Wildcard VLOOKUP
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
