DMIN criteria definition

[Alex]

hi

i try to define criteria for DMIN for the following problem:

Sheet 1 contains the source data in two colums: "Milestone
ID" and "Data", where "Milestone ID" may contain the same
entry several times (e.g. "3").

Sheet 2 contains two colums: "Milestone ID" and "Data",
where "Milestone ID" is only represented exactly once for a
given number.

I would like to automate Sheet 2, column "Data" to provide
me for each unique "Milestone ID" the lowest "Data" from
Sheet 1 among all those Milestones with that ID.

I use the formula
DMIN(Source_Data;"Data";A1:A2) so far. But this does only
work for the first item in Sheet 2, as the "Criteria" field
always requires a label in the first row.

Can anybody help? I would appreciate a lot!

Cheers

 

[Aladin Akyurek]

Try the Data Table method described here:

http://makeashorterlink.com/?D29622D06

or use:

=MIN(IF(Range1 RelOp Condition,Range2)

where RelOp is one of: =,>,<,>=,<=, and <>. The formula needs to be
confirmed with control+shift+enter, not just with enter.