假设：A1=10 B1=5 C1=A1,A2=20 B2=15 C2=B1,A3=30 B3=25 C3=A2,A4=40 B4=35 C4=B2.我将C1、C2圈选起来,接著利用右下角的+,下拉套用,却变成C1=A1 C2=B1 C3=A3 C4=B3 C5=A5 C6=B5.(以此类推),而不是我要的C1=A1 C2=B1 C3=A2 C4=B2 C5=A3 C6=B3.(以此类推),该如
网友回答
c1=OFFSET($A$1,(INT(ROW()-1))/2,MOD(ROW()-1,2))
下拉