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

[µo°Ý] ®æ¦¡¤Æ±ø¥ó-¤½¦¡-°¸¼ÆÄæ-¦p¦ó§PÂ_¦³¸ê®Æ¦A°µ¦¹ÅÜ°Ê

[µo°Ý] ®æ¦¡¤Æ±ø¥ó-¤½¦¡-°¸¼ÆÄæ-¦p¦ó§PÂ_¦³¸ê®Æ¦A°µ¦¹ÅÜ°Ê

=MOD(ROW(),2)=0
¦¹«ü¥O¥Ø«e¥Î¦b®æ¦¡¤Æ«O®æ®É¦p¦óÅý¥L¦³¸ê®Æ¦A¨Ì¦¹±ø¥ó¦A°µÅܦâ

¦^´_ 3# ML089

·PÁÂÀ°¦£¡I¡I¡I¡I

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2015-5-29 09:42 ½s¿è

=(MOD(ROW(),2)=0)*(INDIRECT("A"&ROW())<>"")

"A"ªí¥ÜAÄæ¡A½Ð¨Ì¸ê®ÆÄæ¦ì¦Û¦æ­×¥¿
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

  1. =MOD(ROW()+1,2)*(A1<>"")
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¦a¤WºØ¤Fµæ¡A´N¤£©öªø¯ó¡F¤ß¤¤¦³µ½¡A´N¤£©ö¥Í´c¡C
ªð¦^¦Cªí ¤W¤@¥DÃD