Buzz
You can use the DMAX function in Google Sheets to find the maximum value based on specific conditions. For instance, if you have a data table of your customers' outstanding balances, you can employ the DMAX function to discover the longest outstanding balance for each customer.
HOW TO USE DMAX FUNCTION IN GOOGLE SHEETS
In this example, I'll be using a data table on Sheet 2
I'll create a summary table on Sheet 1 to gather information about customers with the longest outstanding balances.
Step 1: I create the Outstanding Balance Summary Table on Sheet 1. I set up a column named Client Own Money and another column for Oldest Outstanding Payment
Then, you input the data into the Client Own Money cell
Step 2: Input the formula =dmax( into cell B6 on Sheet 1
Then, use the mouse to highlight the entire data table on your Sheet 2. In my article, it will be 'Sheet 2'!A5:E13, as the data table includes headers. Press F4 to transform the formula into an absolute formula. It will become 'Sheet 2'!$A$5:$E$13
Step 3: Add a comma to the fx bar along with double quotes for the column header from the data table you want to return values. In my case, it's Age.
Step 4: Add another comma, and then enclose conditions for retrieving the corresponding result from Sheet 2 within curly braces {}. In my example, it will be {'Client'; A6}. A6 refers to the cell on Sheet 1
Step 5: Press Enter to complete the formula and get the result. Then, drag down to fill the cells below.
Here is a guide on using the DMAX function in Google Sheets to find the maximum value. If you encounter difficulties during the process, feel free to comment below, and Mytour's technical team will assist you. Similar to Excel, Google Sheets also has many other basic mathematical functions. All the basic functions in Excel can be applied in Google Sheets; you just need to master all the basic functions in Excel.
