½Ð°Ý¥i«ü©w¦r¦ê-¤£«½Æ¼Æ¶q«á-¦A«¤¤§ä¥X«ü©w±ø¥ó¦U¼Æ¶q¦³¦h¤Ö¶Ü¡H
- ©«¤l
- 471
- ¥DÃD
- 121
- ºëµØ
- 0
- ¿n¤À
- 579
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-16
- ³Ì«áµn¿ý
- 2023-1-17
|
½Ð°Ý¥i«ü©w¦r¦ê-¤£«½Æ¼Æ¶q«á-¦A«¤¤§ä¥X«ü©w±ø¥ó¦U¼Æ¶q¦³¦h¤Ö¶Ü¡H
|
|
|
|
|
|
- ©«¤l
- 471
- ¥DÃD
- 121
- ºëµØ
- 0
- ¿n¤À
- 579
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-16
- ³Ì«áµn¿ý
- 2023-1-17
|
RE: ½Ð°Ý¥i«ü©w¦r¦ê-¤£«½Æ¼Æ¶q«á-¦A«¤¤§ä¥X«ü©w±ø¥óÁ`¼Æ¦³¦h¤Ö¶Ü¡H
¥»©«³Ì«á¥Ñ starry1314 ©ó 2015-5-19 16:27 ½s¿è
¦^´_ 1# starry1314
ÁÙ¬O»¡¥i¥Î=SUMPRODUCT(1/COUNTIF(rn,rng)*(MMULT(ISNUMBER(FIND(MID(¢Ï$¢°,{1,2},1),rng))*1,{1;1})=2))
¨º¢ú¢ö¢ï¦p³]¦¨¢Ï©M¢ÐÄæ·|¤£·|¦³°ÝÃD©O¡H
Ū¨úÄÝ©ó¢Ï¢°¡×¢ß¡@¦bŪ¨ú¢Ñ¢±¡×¡@ÂD³½¡@ªºÁ`p¼Æ¶q¡@
¢ß¡@¥D¹¡@ÂD³½¡@¡@¢±
¢à¡@¥D¹¡@ÂD³½¡@¡@¢°
ÁÙ¬O»¡¥i¦b¤W¤èªº«ü¥O¿z¿ï§¹«áªº¼Æ¶q¡A¦b«ü¥O¥[¤W¢ë¢÷¢ý¢ö¢ñ¢î¡@«ü©w¢Ñ¢±¥X²{ªº¦¸¼Æ¶Ü¡H |
|
|
|
|
|
|
- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-3
|
http://blog.xuite.net/hcm19522/twblog/350501156 |
|
|
|
|
|
|