1 | Database_arr | |||||
---|---|---|---|---|---|---|
2 | Key | Recipe | Category | Preparation | Calories | |
3 | 1 | Caprese Salad | Vegetarian | 5 | 200 | |
4 | 2 | Burrito Eroica | Epicurean | 10 | 1900 | |
5 | 3 | Celery Rawshticks | Vegan | 3 | 100 | |
6 | 4 | Linguine al Pesto | Vegetarian | 15 | 400 | |
7 | 5 | Swiss-Mushroom Burger | Epicurean | 14 | 700 | |
8 | 6 | Nutella Sandwich | Vegetarian | 3 | 440 | |
9 | 7 | Paella Valenciana | Epicurean | 40 | 650 | |
10 | 8 | Risotto Milanese | Vegetarian | 30 | 600 | |
11 | ||||||
12 | ||||||
13 | Criteria_arr | |||||
14 | Key | Recipe | Category | Preparation | Calories | |
15 | Epicurean | <20 | ||||
16 | ||||||
17 | The highest value | Formula | ||||
18 | 1900 | =DMAX($A$2:$E$10, "Calories",$A$14:$E$15) | ||||
19 | 1900 | =DMAX($A$2:$E$10,E2,$A$14:$E$15) | ||||
20 | 1900 | =DMAX($A$2:$E$10,5,$A$14:$E$15) | ||||
21 | 1900 | =DMAX('General Usage'!$A$2:$E$10,5,$A$14:$E$15) | ||||
22 |
1 | Criteria_arr | ||||||
---|---|---|---|---|---|---|---|
2 | Key | Recipe | Category | Preparation | Preparation | Calories | |
3 | >3 | <=35 | |||||
4 | |||||||
5 | |||||||
6 | The highest value | Formula | |||||
7 | 1900 | =DMAX('General Usage'!$A$2:$E$10,5,$A$2:$F$3) | |||||
8 |