Hi guys.
I really hope you could help me with this one.
My table is:
A B
0.71 1
0.26 0
1.11 0
1.11 1
7.63 1
0.19 0
0.16 0
3.00 1
0.17 0
0.17 0
0.17 0
0.17 0
1.24 1
1.68 2
2.54 2
1.01 2
1.65 2
2.11 2
1.01 2
1.85 2
2.45 2
2.07 2
So I have the A column tat consists of, let's say, electricity consumption of a house and the B column that consists of, say, the number of occupants in the house.
Now, I want to use the MIN & MAX functions on the A column to get, respectively, the MAXimum value from the A column and the MINimum value from the A column.
But, now comes the tricky part. I want to do so with excluding the cells that have the number 0 next to them in column B.
In other words, I need a function that'll tell Excel: "Find the MAX & MIN values from range A1:A20. Put into the calculation only the cells in the range that have a number larger than zero in the cell directly to their right."
Of course, my actual project is in a much larger scale.
BTW, I use Excel 2010.
Thank you very much
Bookmarks