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?
=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?
