Hi there!

I'm trying to use the excel DMIN function on a range of cells, but the database field of the function will vary with the value of the cell directly above each cell that has the DMIN function.

Basically, this is what I want to do: "=DMIN(XXXXXXXXXXX,1,values$A$1:$A$3)", where column 1 of the sheet this is referring to has a unique ID number and $A$1:$A$3 is a criteria list. What I'm trying to do is get the DMIN formula in cell XY to give me the first ID number meeting my criteria from the database starting one row beneath the row of the ID number referred to in the cell above cell XY. So far I haven't been able to figure out how to define the database to give me what I want. I can't do it with a static reference, and the OFFSET function isn't working for me. Does anybody have any ideas? If I'm not being clear enough, please bug me for more information.

Thank you!!!!