- ©«¤l
- 8
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 59
- ÂI¦W
- 208
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- Office 2013
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2018-7-18
- ³Ì«áµn¿ý
- 2024-10-22
|
½Ð°Ý¦U¦ì¤j¤j
§ÚªºÀx¦s®æ¤½¦¡¦p¤U,¦]¬°·QÅã¥Ü¨ä¤¤ªº1~6Ó¦r,©Ò¥H·Q¥ÎMID¨ç¼Æ¨ÓÅã¥Ü,¦ý¸Õ¹L¦hÓ¦ì¸m³£µLªkÅã¥Ü,
©Ò¥H·Q½Ð°Ý³oÓMID¨ç¼Æn©ñ¦bþÓ¦ì¸m¤~¬O¥¿½Tªº?
©Î¬O¦³¨ä¥L¨ç¼Æ¥i¨ú¥N¨Ï¥Î,ÁÂÁÂ
IFNA(CONCATENATE(FILTER('ªí³æ¦^À³ 1'!$U:$U,('ªí³æ¦^À³ 1'!$C:$C=A2)*('ªí³æ¦^À³ 1'!$D:$D=$F$1)*('ªí³æ¦^À³ 1'!$E:$E='²M³æ'!$D$15))),"")
©ñ¦b¥H¤U³oÓ¦ì¸m«hÅã¥Ü#ERROR!
IFNA(MID(CONCATENATE(FILTER(F12,1,6,('ªí³æ¦^À³ 1'!$U:$U,('ªí³æ¦^À³ 1'!$C:$C=A12)*('ªí³æ¦^À³ 1'!$D:$D=$F$1)*('ªí³æ¦^À³ 1'!$E:$E='²M³æ'!$D$15)),"")))) |
|