ExcelBanter - offset function

ExcelBanter (https://www.excelbanter.com/)

- About this forum (https://www.excelbanter.com/about-forum/)

- - offset function (https://www.excelbanter.com/about-forum/31322-offset-function.html)

hidden_stairway

offset function

hello
i am trying to set the reference in an offset function to equal the lowest number in a list without arranging the list in ascending or descending order. i have tried =offset(small(f10:f70,1),0,1,1,1), but it doesnt seem to work... can anyone shed any light on this problem? thanks

brad

All times are GMT +1. The time now is 10:26 PM.