In this Excel Tutorial I will show you how to use Database Max Function using Excel 2010.
For purpose of this tutorial I will use Packing slip Template.
Database Max Function is looking for the maximum value base on criteria.
I will show you basic example of Database Max Function.
I am looking for the highest price for 150 flowers or more. At the top you can see my criteria and the table, below.
Now, I will go to Formula bar and type : equal and DMAX. When I select the correct function I click insert function (fx)
I can see the Function Arguments table where I will select database. My database is my table.
The Field - in my case it will be column Price. I select this.
At the end I select the Criteria and select OK. Picture below show you this step.
You can find Database Max Function of you go to Formulas tab. and click Insert Function.
I select Database function in select a category field. Below, I have list with function and I select DMAX function-OK.
I get the same Arguments Function window.
I hope this Excel Tutorial was helpful.
Katie and Emil.