Hi,
I am trying to return the month number (row 4) for which I have the first
value appearing on row7. It works fin with this formulae
{=INDEX($U$4:$EJ$4,MATCH(TRUE,U7:EJ7<0,0))}
However, if I change the values on row 7 so now the first value appears one
month earlier or later, the array function still returns the same number.
Also I would like to copy and paste the formula for row,8,9 without
systematically doing CTRL+SHIFT+ENTER manually.
Can you help? thank you
--
caroline

Are you sure you have calculation set to automatic? (Tools Options
Calculation tab)
Alternatively, are you sure you have nothing (such as a space) left in the
cell when you change the values on row 7?

Ordinary copy/paste should correctly copy an array formula. Have you tried
this?

"caroline" wrote in message
...
Hi,
I am trying to return the month number (row 4) for which I have the first
value appearing on row7. It works fin with this formulae
{=INDEX($U$4:$EJ$4,MATCH(TRUE,U7:EJ7<0,0))}
However, if I change the values on row 7 so now the first value appears
one
month earlier or later, the array function still returns the same number.
Also I would like to copy and paste the formula for row,8,9 without
systematically doing CTRL+SHIFT+ENTER manually.
Can you help? thank you
--
caroline

Thanks Stephen. I feel so stupid (I ahve setup a calculation set to manual
when i activate the sheet and forgot about it...I must be tired)
--
caroline


"Stephen" wrote:

Are you sure you have calculation set to automatic? (Tools Options
Calculation tab)
Alternatively, are you sure you have nothing (such as a space) left in the
cell when you change the values on row 7?

Ordinary copy/paste should correctly copy an array formula. Have you tried
this?

"caroline" wrote in message
...
Hi,
I am trying to return the month number (row 4) for which I have the first
value appearing on row7. It works fin with this formulae
{=INDEX($U$4:$EJ$4,MATCH(TRUE,U7:EJ7<0,0))}
However, if I change the values on row 7 so now the first value appears
one
month earlier or later, the array function still returns the same number.
Also I would like to copy and paste the formula for row,8,9 without
systematically doing CTRL+SHIFT+ENTER manually.
Can you help? thank you
--
caroline