Copy Array Formula in 2013

Spomone · Jun 6th 2016

Hello - I have an array formula that pulls record based on meeting certain criteria. The formula only works in the first row - I have copied the formula down, but am getting errors in the results. Can someone please look at my file (attached) and see if you can figure out what I am doing wrong?forum.ozgrid.com/index.php?attachment/69343/? Thank you all!

*XOR LX* · Jun 7th 2016

Re: Copy Array Formula in 2013

Hi.

There is not a single error in the whole of that workbook.

Regards

sktneer · Jun 10th 2016

Re: Copy Array Formula in 2013

Hi Spomone,
Welcome to the forum.

You forgot to lock the cell references used in the formula. Try this....

On Train Sheet,
In D4

Code

=IFERROR(INDEX(Vol!C$4:C$2000,SMALL(IF(Vol!$B$4:$B$2000=$A$2,ROW(Vol!$C$4:$C$2000)-ROW(Vol!$C$4)+1),ROWS(C$4:C4))),"")

Confirm with Ctrl+Shift+Enter and then copy across and down.

Copy Array Formula in 2013

Participate now!

Share

Users Viewing This Thread