Array formula Not Working - Help

Dear All,

I am try to extract the data using the below formula, but it is not working. Sample file attached...

{=IFERROR(INDEX('CR Tracker'!D$3:D$646,SMALL(IF('CR Tracker'!AC$3:AC$646>=Report_Summary!$D$2)*('CR Tracker'!AC$3:AC$646<=Report_Summary!$F$2)*(Report_Summary!=$D$4),ROW(Report_Details!$B$6:$B$200)-ROW(Report_Details!$B$6)+1," "),ROWS(Report_Details!$B$6:H6))),"")}

Please help.

Gem

Try

=IFERROR(INDEX('CR Tracker'!D$3:D$646,SMALL(IF(('CR Tracker'!AC$3:AC$646>=Report_Summary!$D$2)*('CR Tracker'!AC$3:AC$646<=Report_Summary!$F$2)*('CR Tracker'!F$3:F$646=Report_Summary!$D$4),ROW('CR Tracker'!D$3:D$646)-ROW($D$3)+1," "),ROWS($D$3:D3))),"")


Plus make ranges consistent

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Thanks a lot John.. It's working perfectly...

Thank you for the feedback and rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.