I got a question from an excel exercise that I don't understand. Using two named ranges (Database
Fantastic news! We've Found the answer you've been seeking!
Question:
I got a question from an excel exercise that I don't understand. "Using two named ranges (Database and Criteria), set up an advanced filtering section which uses AND-based filter for the filtering criteria entered in the Criteria named range. Using the same named ranges, use database functions to calculate the total, minimum, average and maximum values for the listed headings." What does these mean and how to do it?
Posted Date: