正負數值 分開提取 (10527)

E2:I10{=IF(MOD(COLUMN(A1),3),OFFSET($A$1,MAX(SMALL(IF(SIGN($B$2:$B$10)*(1-(COLUMN(A1)>3)*2)>0,ROW($1:$9),99),ROW(A1))),MAX(MOD(COLUMN(A1),3)-1))&"","")