Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Offset
when using offset to refer to a range that changes, can i refer to a specific
range rather than a column? I am using a formula that Bernie helped me with yesterday. It won't calculate when there are blanks. The formula is: =INDEX([NEAST2_1.XLW]Sheet7!$A$42:$A$51, IF(ISERROR(MATCH(-MIN(ABS([NEAST2_1.XLW]Sheet7!$N$42:$N$51)), [NEAST2_1.XLW]Sheet7!$N$42:$N$51, 0)),MATCH(MIN(ABS([NEAST2_1.XLW]Sheet7!$N$42:$N$51)), [NEAST2_1.XLW]Sheet7!$N$42:$N$51, 0),MATCH(-MIN(ABS([NEAST2_1.XLW]Sheet7!$N$42:$N$51)), [NEAST2_1.XLW]Sheet7!$N$42:$N$51, 0))) Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offset | Excel Discussion (Misc queries) | |||
Offset | Excel Worksheet Functions | |||
SUM() and OFFSET() CAUSES #VALUE | Excel Worksheet Functions | |||
offset | Excel Worksheet Functions | |||
SUM(OFFSET)? | Excel Worksheet Functions |