Hi,
I have the below array formula which works fine until it picks up no data when it displays #num error. Is ther any way I can add someting in this formula not to show #num.
Thanks.
=INDEX(DB!$M$2:$M$24077, SMALL(IF($A$1=DB!$B$2:$B$24077,ROW(DB!$B$2:$B$24077)-ROW(DB!$B$2)+1),ROW(DB!1:1)))
I have the below array formula which works fine until it picks up no data when it displays #num error. Is ther any way I can add someting in this formula not to show #num.
Thanks.
=INDEX(DB!$M$2:$M$24077, SMALL(IF($A$1=DB!$B$2:$B$24077,ROW(DB!$B$2:$B$24077)-ROW(DB!$B$2)+1),ROW(DB!1:1)))