ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Ãö©ó¨Ï¥Îexcel°µ­«·s±Æ¦C

¦^´_ 9# wei9133


C1:
=IF(A1="","",ROUNDUP(COUNTA(A:A)/2,)*MOD(ROW(A2),2)+INT(ROW(A2)/2))

E1:
=IF(A1="","",INDEX(A:A,ROUNDUP(COUNTA(A:A)/2,)*MOD(ROW(A2),2)+INT(ROW(A2)/2)))

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD