Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
trying to find the smallest with dynamic column changes
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(),Colu mn()-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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
trying to find the smallest with dynamic column changes
Try...
=MIN(IF(INDEX(4:4,3):H40,INDEX(4:4,3):H4)) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps! In article , "Andy" wrote: 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(),Colu mn()-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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
How do I find a column entry closest to a particular value | Excel Worksheet Functions | |||
How do I find a column entry closest to a particular value | Excel Discussion (Misc queries) |