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

½Ð°Ý¦p¦ó±N¤å¦rÂন­È¡A¨Ã±Æ§Ç?

¦^´_ 10# gaishutsusuru

¤Ö¥´ IF

­Y­nÂX¤j½d³ò
=SMALL(IF(A$2:A$99="","",VALUE(A$2:A$99)),ROW(A1))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 11# ML089


   ÁÂÁ±z¡A¤½¦¡¥i¥H¥Î¤F¡C
:)

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD