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

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

¦^´_ 6# ziv976688

­Y¬O 2003ª©¨S¦³ IFERROR ¨ç¼Æ¥i¥H¨Ï¥Î¡A¤]¥i¥Î¨ä¥L¤è¦¡¡A¨Ò¦plookup

B14 =LOOKUP(1,IF({1;0},{0,""},INDEX(5:5,SMALL(IF(COUNTIF($B7:$K7,$B5:$I5)=0,COLUMN($B5:$I5)),COLUMN(A1)))^{0,1}))
¤TÁä¿é¤J ¥k©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

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

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 14# hcm19522
·PÁ±zªºÀ°¦£!

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD