SUMPRODUCTµLªk§P§O??*¸U¥Î¦r¤¸¶Ü
- ©«¤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# joey3277
¦pªG¤@©wn¥Î¸U¥Î¦r¤¸ªº¸Ü¥i§ï¬°- ISNUMBER(1/(SEARCH("??11*",$B$4:$B$17)=1))
½Æ»s¥N½X ì²z¡G
SEARCH¥i¨Ï¥Î¸U¥Î¦r¤¸ ¦]¦¹SEARCHªºªF¦è¦pªG¬O¦b²Ä¤@Ó¡A«h²Å¦X쥻·Q¨Ï¥Îªº¸U¥Î¦r¤¸
¦ý¬OSEARCH¤£¨ìªº³£·|¬O#VALUE!¿ù»~¡A¤£µ¥©ó1ªº·|¬OFALSE¡Aµ¥©ó1ªº¬OTRUE
¦A¨ú˼ơA¦]¦¹FALSEªº·|Åܦ¨DIV!0¿ù»~¡ATRUEªº´NÅܦ¨1¡A¦]¦¹¥~±¦A¥]¤@¼hISNUMBER¡A´N¥u¦³SEARCH("??11*",$B$4:$B$17)=1ªº·|¬OTRUE¡A¨ä¾l³£¬OFALSE
¬O»¡³oÓªF¦è¥»¨Ó´N·|¬O0¡A¦]¬°µ¥©ó7¥B¬O"??11*"ªº¸ò¥»´N¤£¦s¦b°Ú
§A¥»¨ªº»Ý¨D§Ú¨ä¹ê¬Ý¤£¤ÓÀ´¡K¡K¨ì©³§A¾ãÓªí¬Onºâ¤°»ò¡H |
|
|
|
|
|
|