G
Guest
Hi,
I am using an array function to lookup maximum and minimum values between to
two dates (see below). The array function for MAX() works perfectly fine.
However, once I substitute MIN for MAX and hit ctrl+shift+enter, the output i
zero, even though this answer is wrong. (There are no observations with the
value of 0 in the dataset. Nor are there blank observations.)
Does anyone know why the array function with MIN doesn't work?
In advance, thanks for your help.
Henrik
WORKS
{=MAX(Stock_Data!$C$3:$C$1616*($A2<=Stock_Data!$A$3:$A$1616)*($K2>=Stock_Data!$A$3:$A$1616))}
DOESN'T WOR
{=MIN(Stock_Data!$C$3:$C$1616*($A2<=Stock_Data!$A$3:$A$1616)*($K2>=Stock_Data!$A$3:$A$1616))}
I am using an array function to lookup maximum and minimum values between to
two dates (see below). The array function for MAX() works perfectly fine.
However, once I substitute MIN for MAX and hit ctrl+shift+enter, the output i
zero, even though this answer is wrong. (There are no observations with the
value of 0 in the dataset. Nor are there blank observations.)
Does anyone know why the array function with MIN doesn't work?
In advance, thanks for your help.
Henrik
WORKS
{=MAX(Stock_Data!$C$3:$C$1616*($A2<=Stock_Data!$A$3:$A$1616)*($K2>=Stock_Data!$A$3:$A$1616))}
DOESN'T WOR
{=MIN(Stock_Data!$C$3:$C$1616*($A2<=Stock_Data!$A$3:$A$1616)*($K2>=Stock_Data!$A$3:$A$1616))}