A set of replacements for the Excel database functions. The advantages are: 1. You can specify the criteria in the formula instead of having to use an external range, 2. You can copy the formulas down a column and the criteria will change accordingly if you use string 'concatenation'. 3. You can use parentheses to prioritize certain criteria over others.
|