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

½Ð°Ý¤½¦¡¡G§PÂ_¼Æ¦r¬O§_¬Û¦P¡B¥X²{¤F¤°»ò¼Æ¦r?

¦^´_ 1# gaishutsusuru

E2 =IF(COUNT(0/FREQUENCY(A2:D2,A2:D2))=1,"","OK")
F2 =IF(E2="OK","-",LOOKUP(,0/A2:D2,A2:D2))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD