May not be elegant, but here's _one_ other approach which may work for
you... And it doesn't require an array:
Assuming the values are in cells A2:A10 with a caption in A1;
Caption any other cell (let's say H7) with the same caption and in the cell
beneath it (H8) enter >0 - those two cells serve as a "Criteria Range", then
write a DMIN fx like this:
=DMIN(A1:A10,A1,H7:H8)
You can also change or delete the ">0" in the criteria range (H8 in this
case) any time you wish & the fx will update accordingly.
HTH |:>)
Bob Jones
[MVP] Office:Mac
Thanks, Bob. Back when Excel was new I always used the database
functions. Somehow I forget about how versatile they are.
Ed