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

[µo°Ý] ¼W¼g¦V¥ª¶ñº¡ªº¤½¦¡

¦^´_ 2# ML089
ªþ¥ó :    TEST_1.rar (2.51 KB)
ª©¤j : ±z¦n !
¤£¦n·N«ä~¦³2­Ó°ÝÃD·Q¦V±z½Ð±Ð :
B10
=IF(ISERROR(MOD(SMALL(IF(COUNTIF(7:7,$B5:$Z5)=0,$B5:$Z5+COLUMN($B:$Z)*10^5),COLUMN(A1)),10^5)),"",MOD(SMALL(IF(COUNTIF(7:7,$B5:$Z5)=0,$B5:$Z5+COLUMN($B:$Z)*10^5),COLUMN(A1)),10^5))
1_¥½¾Ç¤£¤Ó²z¸Ñ~¤½¦¡¤¤¬°¦ó·|»Ý­n¥Î¨ì¨ú¾l¼ÆªºMOD¨ç¼Æ?

2_¦pªG²Ä5¦C¦³Åã¥Ü¼Æ¦rªºÄæ¦ì¤£½T©w¡A¦p¦ó±N¤½¦¡¶W©ÔªºÄæ¦ìÅã¥Ü""¡C
EX : B10ªº¤½¦¡¡C

¥H¤W    Àµ½Ð½ç±Ð     ÁÂÁ±z !

TOP

¦^´_ 7# ML089
1_ÁA¸Ñ¬°¦ó­n±Ä¨úMOD¨ç¼Æªº¥Î·N¤F~ÁÂÁ±zªº­@¤ß»¡©ú~·P®¦
2_¦hºØ±N¤½¦¡¶W©ÔªºÄæ¦ìÅã¥Ü""ªº»¡©ú~¨ü´f¨}¦h

TOP

¦^´_ 11# ML089
ª©¤j :
±zªº¨ç¼Æ¤½¦¡­×¬°¯u¬OÄl¤õ¯Â«C~¨ØªA !

³Ì«á¥½¾Ç±Ä¥Îªº¬O :
B12 =INDEX(5¡G5,SMALL(IF(COUNTIF($B7¡G$K7,$B5¡G$I5)=0,COLUMN($B5¡G$I5),99),COLUMN(A1)))&""
B14 =LOOKUP(1,IF({1;0},{0,""},INDEX(5¡G5,SMALL(IF(COUNTIF($B7¡G$K7,$B5¡G$I5)=0,COLUMN($B5¡G$I5)),COLUMN(A1)))^{0,1}))
¦]¬°³o2­Ó¤½¦¡¥i¥H¤£¸j©w¦ì§}~¦bB¡GAY¯B°Êªº½d³ò¤º³£¥i¾A¥Î¡C

ÁÂÁ±z­@¤ßªº«ü¾É¦h­Ó¤½¦¡~¨ü´f¨}¦h~·P®¦

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD