close
LV超3A名牌購物網
設立名稱定義:
A
=INDIRECT("$A$7")-1
I
=INDIRECT("$I$7")-1
當以A欄期數為計算基準，則
T7
=IF(OR(T$6="",$S7="",$R7>=T$5,T$3<=1),"",IF(OR($S7=OFFSET($A$6,$R7+T$3-A,1,,7))*OR($R$5=OFFSET($A$6,$R$6-A,1,,7)),$R7+T$3,""))
陣列~右拉下拉填滿
當以I欄期數為計算基準，則
T7
=IF(OR(T$6="",$S7="",$R7>=T$5,T$3<=1),"",IF(OR($S7=OFFSET($I$6,$R7+T$3-I,1,,7))*OR($R$5=OFFSET($I$6,$R$6-I,1,,7)),$R7+T$3,""))
陣列~右拉下拉填滿
參考附件︰LV超3A名牌購物網
A
=INDIRECT("$A$7")-1
I
=INDIRECT("$I$7")-1
當以A欄期數為計算基準，則
T7
=IF(OR(T$6="",$S7="",$R7>=T$5,T$3<=1),"",IF(OR($S7=OFFSET($A$6,$R7+T$3-A,1,,7))*OR($R$5=OFFSET($A$6,$R$6-A,1,,7)),$R7+T$3,""))
陣列~右拉下拉填滿
當以I欄期數為計算基準，則
T7
=IF(OR(T$6="",$S7="",$R7>=T$5,T$3<=1),"",IF(OR($S7=OFFSET($I$6,$R7+T$3-I,1,,7))*OR($R$5=OFFSET($I$6,$R$6-I,1,,7)),$R7+T$3,""))
陣列~右拉下拉填滿
參考附件︰LV超3A名牌購物網
全站熱搜
留言列表
