Microsoft Office Tutorials and References
In Depth Information
Examples of Database Functions
Figure 12.50.
Figure 12.50. After you see working examples, it is easy to add new
After you see working examples, it is easy to add new
FILTERXML
FILTERXML formulas.
formulas.
Examples of Database Functions
If you were a serious data analyst in the 1980s and the early 1990s, you
would have been enamored with the database functions. I personally used
@DSUM every hour of my work life for many years. It was one of the most
powerful weapons in any spreadsheet arsenal. Combined with a data table,
the DSUM, DMIN, DMAX, and DAVERAGE functions got a serious workout when
users performed data analysis in a spreadsheet.
Then, in 1993, Microsoft Excel added the pivot table to the Data menu in Excel.
Pivot tables changed everything. Those powerful database functions seemed
tired and worn out. Since that day in 1993, I had never used DSUM again until
I created the example described in the following section. As far as I knew, the
database functions had been living in a cave in South Carolina.
Maybe it is like the nostalgia of finding a box of photos of an old girlfriend,
but I realized that the database functions are still pretty powerful. Cus-
tomers whined enough to have Microsoft add AVERAGEIF to the COUNTIF
and SUMIF arsenal. This was unnecessary: Customers could have done this
easily by setting up a small criteria range and using DAVERAGE.
Search JabSto ::




Custom Search