Excel Magic Trick 1217: D Functions: Text Criteria: “Starts With”, “Exact” and “Contains”
Автор: excelisfun
Загружено: 2015-07-31
Просмотров: 23434
Описание:
Download Excel Start File: https://excelisfun.net/files/EMT1218-...
Download File: https://excelisfun.net/
For Text Criteria in D Functions (Like DSUM, DCOUNT, DMAX) learn about the difference between: “Starts With”, “Exact” and “Contains” Criteria.
1. (00:10) Problem Setup
2. (00:47) “Starts With” Criteria requires that you just type text into cell.
3. (01:08) Basics of D Functions Database Functions in Excel.
4. (03:03) “Exact” Criteria requires that you create a text formula with the text and the comparative operator equal sign.
5. (04:08) “Contains” Criteria requires that you use the wild card asterisk before and after the text, where asterisk is a wild card that stands for zero or more characters
Thanks to Excel.i Adam at YouTube!!
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
