=DMIN(database,field,criteria) question about criteria
Dummy wrote...
....
My question is insted of using Criteria geting form the sheet i
want to manual input the criteria in formulla like
=DMIN($A$1:$A6,B1,"Fuite"="Apple")
since i have a long sheet and i will fix the formula in each cell.
also there are many items so i do not want to change the criteria
for every items. is there anyway? How can i do it? Can anyone help?
Don't use DMIN. Use an array formula like
=MIN(IF($A$2:$A$6="Apple",$B$2:$B$6))
You could use DMIN as the formula for a data table, but it's still
klunky.
|