Hello Everyone… Can Anyone Help Me With This Situation… What I'm Try To Do Is:
In Column B When I marked with an "X", Column Should Show What Is In Column A... A Bit Comfusing But Here Are The Formula I'm Using.
Say In A2 = Product1
In G2 =IF(B2<>"",ROW(),"")
In E2{=IF(ROW($A2:$A16)-ROW($B$2)+1>COUNT(G2:G16),"",INDEX($A:$A,SMALL(G2:G16,ROW(INDIRECT("1:"&ROWS(B2:B16))))))}
I've also noticed that From row 2 - 8 The formula works... But from row 9 onwards it's not working.... And also I've noticed that when I change the formula in E2, All the others to E8 changes automatically leaving the rest from E9... Any suggestions... How can I change a part of an array formula???
In Column B When I marked with an "X", Column Should Show What Is In Column A... A Bit Comfusing But Here Are The Formula I'm Using.
Say In A2 = Product1
In G2 =IF(B2<>"",ROW(),"")
In E2{=IF(ROW($A2:$A16)-ROW($B$2)+1>COUNT(G2:G16),"",INDEX($A:$A,SMALL(G2:G16,ROW(INDIRECT("1:"&ROWS(B2:B16))))))}
I've also noticed that From row 2 - 8 The formula works... But from row 9 onwards it's not working.... And also I've noticed that when I change the formula in E2, All the others to E8 changes automatically leaving the rest from E9... Any suggestions... How can I change a part of an array formula???