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

¦p¦ó¼¶¼g¤½¦¡¡G¦pªG¦³¤@¦C¸ê®Æ¡A·Q­n§ä¨ì²Ä¤@­Ó¦³¼Æ¦rªº¦a¤è¡C

¦p¦ó¼¶¼g¤½¦¡¡G¦pªG¦³¤@¦C¸ê®Æ¡A·Q­n§ä¨ì²Ä¤@­Ó¦³¼Æ¦rªº¦a¤è¡C

1st_Column.zip (8.99 KB)

1st_Column.zip (8.99 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2013-11-20 14:27 ½s¿è

¦^´_ 1# Baracuda

¤u§@ªí¡u¨Ò¡v¤§Àx¦s®æA2¿é¤J
=MATCH(TRUE,INDEX((B2:K2<>""),0),0)
©Î
=MATCH(FALSE,INDEX((B2:K2=""),0),0)
¥i§_¡H
¤W¦C²Õ¦X¤½¦¡°Ñ¦Ò¦Û http://www.mrexcel.com/forum/excel-questions/349154-find-first-non-blank-cell-row.html ­×§ï¦Ó±o
·Ð½ÐBaracuda¤j½ç±Ð¡AÁÂÁ¡I

TOP

p212ÁÂÁ¡A³o­Ó¥i¥Hwork §Ú¥Î¥Î¦A¸Õ¸Õ¬Ý

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD