Hi, I have written this formula and want to make it more efficient by replacing the OFFSET with INDEX to make it less volatile.
{=MIN(OFFSET(A2,,1,INDEX(MATCH(1,--ISNUMBER(A2:A300),0),)))}
What this formula is doing is finding the first cell below A2 to A300 that contains a value then once that range is found it moves across one column (column B) then finds the min value from column B.
Can you show me another way of making this formula more efficient?
regards
GB
{=MIN(OFFSET(A2,,1,INDEX(MATCH(1,--ISNUMBER(A2:A300),0),)))}
What this formula is doing is finding the first cell below A2 to A300 that contains a value then once that range is found it moves across one column (column B) then finds the min value from column B.
Can you show me another way of making this formula more efficient?
regards
GB