I would like to modify the criteria in the database functions DMIN and DMAX
at the formula level, instead of by entering new value in criteria range cell.

I have a worksheet with the following structu

PN LOC
pn1 101
pn1 102
pn2 201
pn3 202
pn3 203
pn1 401
pn1 402

Would like to add:
a third column calculating the min Loc for that PN
and
a fourth column calculating the max Loc for that PN

Resulting:
A B C D
PN LOC MINLOC MAXLOC
3 pn1 101 101 402
4 pn1 102 101 402
5 pn2 201 201 201
6 pn3 202 202 203
7 pn3 203 202 203
8 pn1 401 101 402
9 pn1 402 101 402

On individual basis, I can use
=DMIN(db,"MINLOC",A1:A2)
where A1="PN" and A2= the desired pnX

But I need to vary the criteria at the function level... ie
=DMIN(db,"MINLOC",PN=pn2)
or
=DMIN(db,"MINLOC",{"PN";"pn2"})

Neither of these work, of course, but hopefully you understand what I'm
getting at.

Eventually, I would have the formula criteria refer to the first column cell
reference
PN=A3 or {"PN";A3} for fiirst row
PN=A4 or {"PN";A4} for second row
etc.

This all would be much easier in Access, but... no access...

Thanks in advance.