aditya7326
New Member
For the below table, I need to write a formula which will calculate the minimum price for all the rows with Include specified as "Yes" and return respective identifier. In this case, the result should be 5 (Column A). I have included the sample file as well.
Identifier Price Include?
1 10 Yes
2 20 Yes
3 5 No
4 23 Yes
5 5 Yes
6 27 Yes
7 35 No
8 87 Yes
9 19 Yes
10 20 Yes
Identifier Price Include?
1 10 Yes
2 20 Yes
3 5 No
4 23 Yes
5 5 Yes
6 27 Yes
7 35 No
8 87 Yes
9 19 Yes
10 20 Yes