- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
|
¥»©«³Ì«á¥Ñ p212 ©ó 2015-5-22 12:44 ½s¿è
¦^´_ 1# mikan
1¡B¿ï¨ú¡u¸ê®Æªí¡vªºA1:F15½d³ò¡A«öCtrl+Shift+F3¡A¤§«á¿ï¾Ü¥H¡u³»ºÝ¦C¡v¬°¦WºÙ¶i¦æ©w¸q¦WºÙ¡C
2¡B¦b¡u±H¥X¦W±ø¡v¤u§@ªí¤§Àx¦s®æB3¿é¤J°}¦C¤½¦¡ (¥HCtrl+Shift+Enter¿é¤J¤½¦¡)
=IFERROR(INDEX(Ápµ¸¤H,SMALL(IF($A2=¥N¸¹_±H«H,ROW(¥N¸¹_±H«H),""),COLUMN(A$1))-1)&" "&"TEL:"&INDEX(¹q¸Ü,SMALL(IF($A2=¥N¸¹_±H«H,ROW(¥N¸¹_±H«H),""),COLUMN(A$1))-1),"")
¦V¥k½Æ»s¤½¦¡(¨Ò¦p¦V¥k©ì²¾½Æ»s¨ìÀx¦s®æG3)
3¡B½Æ»s¡u±H¥X¦W±ø¡v¤u§@ªí¤§Àx¦s®æB3:G3ªº¤½¦¡
¦A¥H¡u¿ï¾Ü©Ê¶K¤W¡v¤§¡u¶K¤W¤½¦¡¡v°õ¦æ¨ä¥LÀx¦s®æªº¤½¦¡¼g¤J§Y¥i
½Ð°Ñ¦Ò¡I |
|