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

Related Articles

Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA? DESCRIPTION From Survey Results, see examples of how to calculate the percentage of No responses given that the response was from a Full Time Faculty in [Read More >>>]

DESCRIPTION MIN and MAX Between Two Dates For Each Region See Mr Excel and excelisfun use two methods to calculate MIN and MAX Between Two Dates For Each Region (Minimum value and maximum value with [Read More >>>]

OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT? DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for each county code, [Read More >>>]