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

¬O§_§t0¡ã9¼Æ¦r

=IF(ISNA(LOOKUP(,-FIND(ROW($1:$10)-1,A1))),"No","Yes")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

=IF(COUNT(FIND(ROW($1:$10)-1,A1)),"yes","no")
»Ý¥Î°}¦C¿é¤J(CTRL+SHIT+ENTER ¤TÁä»ô«ö¿é¤J)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 8# p212

¦pªG­nºâ¦r¦ê¤¤§t¦³¦h¤Ö¼Æ¦r
=COUNT(-MID(A1,ROW($1:$99),1))
°}¦C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD