Issue with DMIN and DMAX Function

You get better help, adding a small excel file, without confidential information.

Please also add the expected result manualy in the file.

Welcome to the forum:

As a guess, I suspect that the CRITERIA part of the DMAX function isn't correct. If you don't need a criteria for the MAX value, you might be further ahead using MAX or LARGE.

As suggested by oeldere, please upload a sample of your data.

Directions:
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Check to make sure that your data really contains values, and not text that looks like a value. Use =isnumber(cell-ref) to test - FALSE indicates you are dealing with text numbers

The "D" (database) functions are very efficient but are seldom used in "modern" spreadsheets because they require cells to define the criteria.

Just using the MIN and MAX functions is much easier.

Define "vast".

I would at least try the MIN/MAX functions to see if there is a performance issue.