Excel Magic Trick 1217


D Functions: Text Criteria: “Starts With”, “Exact” and “Contains”

DESCRIPTION

For Text Criteria in D Functions (Like DSUM, DCOUNT, DMAX) learn about the difference between: “Starts With”, “Exact” and “Contains” Criteria.
(00:10) Problem Setup
(00:47) “Starts With” Criteria requires that you just type text into cell.
(01:08) Basics of D Functions Database Functions in Excel.
(03:03) “Exact” Criteria requires that you create a text formula with the text and the comparative operator equal sign.
(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

WORKBOOKS




Be the first to comment

Leave a Reply