Excel Magic Trick 1214


How To Enter Text Criteria Into Excel Database Functions

DESCRIPTION

See how to Enter Text Criteria Into Excel Database Functions using a Text Formula with the Comparative Operator Equal Sign. See these Examples:
(00:09) Text Criteria for D Functions (Database Function). See how to create a formula with an Equal Sign to make D Functions do an “Exact Match”, rather than the default “Starts With Search”
(00:28) DMAX function to find the Max Value with a Text Criteria
(02:51) DCOUNTA function to count text items that math an Exact Text Criteria
COUNTIFS function to count with Text Criteria

WORKBOOKS




Be the first to comment

Leave a Reply