ªð¦^¦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 : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD