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

[µo°Ý] ¤é´Á+¼Æ¦rªº³Ì«á¤@µ§

[µo°Ý] ¤é´Á+¼Æ¦rªº³Ì«á¤@µ§

½Ð±Ð...
¨ú³Ì«á¤@µ§, =IFERROR(LOOKUP(1,0/$B2:$H2,$B2:$H2),""), ¦]§t¦³¤é´Á, ¤½¦¡´N¤£À´¦p¦ó¤U¤F.

Book1.rar (6.54 KB)

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD