- ©«¤l
- 58
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 117
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2017-12-2
- ³Ì«áµn¿ý
- 2021-12-16
|
¦^´_ 2# hcm19522
±z¦n¡A·PÁ±zªº¦^ÂÐ
¥Ø«e¬Ý°_¨Ó¬O²Å¦X§Ún¥Îªº¼Ë¤l¡A¹L´X¤Ñ¦³n¥Î¨ìªº®ÉÔ¦A°µ¹ê»Ú¾Þ°µ¬Ý¬Ý
¬Ý°_¨Ón¼W¥[¼Æ¶qÀ³¸Ó¬OקïAªºÈ§Y¥i
¦A¦¸·PÁ±z
C2:C65535=IF(A2="","",ROUNDUP(COUNTA(A$2:A$65535)/2,)*(MOD(ROW(A1),2)=0)+INT(ROW(A2)/2))
D2:D65535=IF(A2="","",OFFSET(A$1,ROUNDUP(COUNTA(A$2:A$65535)/2,)*(MOD(ROW(A1),2)=0)+INT(ROW(A2)/2),))
±Æ§Ç.rar (8.05 KB)
|
|