trying to find the smallest with dynamic column changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am currently using C through H to find the find the smallest value by using
the following formula
{=min(if((C4:H4)>0,(C4:H4))}

But now i want to have automatically find the smallest value if i inserted a
new column. So i used this formula

{=min(if(Indirect("C"&Row()&":"&address(Row(),Column()-1))>0,Indirect("C"&Row()&":"&address(Row(),Column()-1)))}

But its not working i am getting a #value error.

So what is wrong, i dont see it
 
Try...

=MIN(IF(INDEX(4:4,3):H4>0,INDEX(4:4,3):H4))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
 
Back
Top