D2{=IFERROR(TEXT(A2/OFFSET(A2,MATCH(1=1,ISERR(0/A2:A17),)-2,),"[<1];"),"")
另解=IFERROR(TEXT(A2/OFFSET(A1,IFERROR(MATCH("*",A2:A17,),19-ROW())-1,),"[=1]! "),"")
另解=IF((A2>9^9)+(A3>9^9)+(A3=""),"",A2/OFFSET(A1,MATCH(1,FREQUENCY(1,(A3:A21>9^9)+(A3:A21="")),),))
留言
張貼留言