A B
1 Fruit Amount
2 Apple 10
3 Banana 12
4 Apple 9
5 Pineapple 8
6 Apple 11
7
8 Criteria
9 Fruit Amount
10 Apple
11
12 Result
10 Apple 9 Formula =DMIN($A$1:$A6,B1,A9:A10)
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?