ªð¦^¦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 : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD