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

[µo°Ý] ROW¨ç¼Æ¦p¦ó²Õ¦X¨ä¥L¨ç¼Æ¡A²£¥Í³sÄò©Ê©_¼Æ½s¸¹¡B°¸¼Æ½s¸¹¡H

[µo°Ý] ROW¨ç¼Æ¦p¦ó²Õ¦X¨ä¥L¨ç¼Æ¡A²£¥Í³sÄò©Ê©_¼Æ½s¸¹¡B°¸¼Æ½s¸¹¡H

°²³]©óÀx¦s®æB2¡AROW(1:1)À³¦p¦ó²Õ¦X¨ä¥L¨ç¼Æ¡A¦b¦V¤U½Æ»s¤½¦¡«á±o¨ì³sÄò©Ê©_¼Æ½s¸¹(1¡B3¡B5...)©Î°¸¼Æ½s¸¹(2¡B4¡B6...)¡H
·q½Ð¦U¦ì¦Ñ®v½ç±Ð¡AÁÂÁ¡I

=ODD((ROW(1:1)*2)-1)
=EVEN((ROW(1:1)*2)-1)

¬O³o¼Ë¶Ü?

TOP

¦^´_ 1# p212

©_¼Æ=ROW(1:1)*2-1
°¸¼Æ=ROW(1:1)*2

TOP

¦^´_ 3# aer
ÁÂÁÂaer¤j»Pjkrubpom¤jªºÀ°¦£¡AOK!

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD