- ©«¤l
- 186
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-11-12
- ³Ì«áµn¿ý
- 2014-4-15
|
¦^´_ 1# Qin
n§äªº¤º®e©ñA¦C¡A³Q§äªº©ñB¦C
C1°}¦C¤½¦¡- =IF(SUM(--ISNUMBER(SEARCH(OFFSET($A$1,,,COUNTA(A:A),),B1))),B1,"")
½Æ»s¥N½X ¤U©Ô¡AµM«á¦A²¾°£«½Æ(¥Î¤½¦¡ªº¸Ü·|¤ñ¸ûºC)
·j´M¸ê®Æ_sol.rar (97.11 KB)
|
|