Hi there,
How can I edit the following array formula not to consider blank cells that contain formulas?
D3 =INDEX(A$3:A$20,AGGREGATE(15,6,ROW(A$3:A$20)/(INDEX($E$3:$J$6,N(IF(1,MATCH($B$3:$B$20,$D$3:$D$6,))),N(IF(1,COLUMN($E$3:$J$6)-COLUMN($D$3))))>0),ROWS(L$3:L3))-ROW(A$2))
Currently, the formula works in a range where blank cells that are truly empty, such as E3:J6 in the attached mock file. However, I get the wrong results when I use it in the actual file where blank cells in a range have formulas. I tried replacing >0 with >"" but nothing happened.
This should be fairly easy but I can't quite get it right.
Appreciate the help!
Cheers
Bookmarks