- ©«¤l
- 678
- ¥DÃD
- 147
- ºëµØ
- 0
- ¿n¤À
- 799
- ÂI¦W
- 0
- §@·~¨t²Î
- win 8
- ³nÅ骩¥»
- MS 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2022-1-20
|
¦^´_ 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®¦
|
|