# Conditional MIN not working in table

#### CTK123

##### New Member
I have a table with monthly consumption data for various facilities, and I am trying to create a formula that finds the lowest value for each facility each year. I used this formula below:

=MIN(([Year]=[@Year])*([Location '#]=[@[Location '#]])*[BTU/SF/day])

Without ctrl+shift+enter as tables don't allow for array formulas. The end result in these cells is just the BTU/SF/Day for each month. What am I missing? The condition x value works great for SUMPRODUCT... I was hoping it would carry over. I tried to convert it back to regular data and do the array formula and it just returns all 0s. Any ideas?

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Anybody?

Replies
3
Views
277
Replies
14
Views
6K
Replies
7
Views
468
Replies
11
Views
2K
Replies
4
Views
430

1,203,047
Messages
6,053,195
Members
444,645
Latest member
mee siam

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back