Copying an array formula

**geoffreynd** · 10-13-2008, 12:34 PM

I have an array formula as follows:

{=INDEX(N13:AA13,MATCH(TRUE,N13:AA13<>0,0))}

Want to copy this down a column. when I do, the formula does not change to accomodate for change in rows (i.e., the 13 does not become 14 then 15 then 16 and so on).

How do i remedy this?

**dominicb** · 10-13-2008, 04:25 PM

Good evening geoffreynd

...and welcome to the forum!!

Originally Posted by geoffreynd

Want to copy this down a column. when I do, the formula does not change to accomodate for change in rows (i.e., the 13 does not become 14 then 15 then 16 and so on).

You need to make the number part of the formula absolute, rather than relative, thus :
{=INDEX(N$13:AA$13,MATCH(TRUE,N$13:AA$13<>0,0))}

HTH

DominicB