Array Formula with #REF! error

[Rcaaa]

Can anyone see the error in my formula? I am trying to extract records for each project description in column G3:G46 from the sheet labeled Tasks.
A2 has the project description and b2 has the count.

=IF(ROWS(A$5:A6)>$B$2,"",Index(Tasks!A$3:A$46,SMALL(IF(Tasks!$G$2:$G$46=$A$2,ROW(Tasks!$G$3:$G$46)-ROW(Tasks!$G$3)+1),ROWS(A$5:A6))))

Thanks,

RCAAA

 

[Marcelo Branco]

See if this works

=IF(ROWS(A$5:A5)>$B$2,"",Index(Tasks!A$3:A$46,SMALL(IF(Tasks!$G$3:$G$46=$A$2,ROW(Tasks!$G$3:$G$46)-ROW(Tasks!$G$3)+1),ROWS(A$5:A5))))
Ctrl+Shift+Enter

M.

 

[Rcaaa]

M,

I am still getting the #REF ! error, but thank you for fixing the discrepancies in my formula.

Thanks again,

RCAAA

 

[Marcelo Branco]

A small data sample (~10 rows) along with expected results would be helpful for testing purposes.

M.

 

[Rcaaa]

Hello,

Thank you M. I tried your formula in a different workbook and it worked.

Thanks again,

RCA