DMIN criteria argument, how to use?
Posted by Andy on September 22, 2001 3:00 PM
I am trying to use the DMIN function to sort a list of values contained in cells. The DMIN function has 3 arguments, the 3rd being a reference to a range of cells containing the criteria for the function.
The function will only consider rows in the database (list of rows) that match the criteria.
I want the insert the following criteria: greater than the value in cell B2. In other words, include this row only if the value in question is greater than the value in cell B2.
If this is possible, how do I refer to the value in a cell in the criteria?
The help files are not very extensive and the examples only show how to do this with a static value (such as >10).
Please reply also to firstname.lastname@example.org
Thanks in advance.