Excel Database Functions are similiar to the *IFS functions, except better. Download the Excel file here: https://www.myonlinetraininghub.com/e...
0:00 Introduction
0:22 Database Function Syntax
1:27 Database Function Example Multiple AND Criteria
3:33 Database Function Example Multiple AND OR Criteria
4:22 Database Function Example Multiple OR Criteria, Same Field
4:52 Database Function Example Multiple OR Criteria, Different Field
5:45 Database Function Example Wildcards
6:39 Database Function Example DGET Function
7:37 Database Function Rules
CAUTION: The multiple OR criteria on different fields example (4) will aggregate all data which is level 1, including level 1 for Atkins (because the name field is blank on the first criteria row), plus all other levels except those that are for Atkins (because the Type field is blank on the second criteria row). Caution: it will double count Level 1 not equal to Atkins and this is probably not what you want.
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: / myndatreacy