daverage-functions

DAVERAGE vs AVERAGEIF & DCOUNT vs COUNTIF

Crispo Mwangi | 4-Dec-16 | Leave a Comment

We have been exploring on database functions for the last two articles ( EXCEL DATABASE FUNCTION and EXCEL DSUM FUNCTION.) This article will examine  DAVERAGE & DCOUNT and how they compare with their equivalent AVERAGEIFS & COUNTIFS. Will the Database functions prevail in terms of speed over their IFS equivalent? DAVERAGE vs AVERAGEIFS For example using below data compute the […]

WILDCARD

WILDCARDS IN EXCEL

Crispo Mwangi | 23-Jul-16 | Leave a Comment

A Wildcard is a symbol used to replace or represent one or more characters. Excel wildcards are either an asterisk * which represents one or more characters, a question mark ? which represents a single character or a tide ~ used to distiguish between normal characters and a wildcard. A tide is rarely used. Examples: ►M* will […]