D

#### De York

at the formula level, instead of by entering new value in criteria range cell.

I have a worksheet with the following structure:

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.