I need help with the ADDRESS function to help me average a range based on the minimum value for columns B to Q. For example, for Column B the lowest value is cell B161. I need a dynamic formula to do this =AVERAGE(B159:B163). Basically, 5 cells. 2 cells above and below and the minimum value. Thanks!
Solved by A. F. in 18 mins