ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¶Ç¦^§ä¨ì¼Æ¦rªº©Ò¦b¦æ(¦³¬Û¦Pªº¼Æ¦r)

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-5 11:48 ½s¿è

¦^´_ 1# t8899
¸Ñ¤@¡G
1¡B©w¸q¦WºÙ¡udata¡v¡A¡u°Ñ·Ó¨ì¡v¿é¤J=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A))¡C
2¡B°²³]©óÀx¦s®æC1¿é¤J°}¦C¤½¦¡
=SMALL(IF(data=$E$1,ROW(data),""),ROW(1:1))
¦V¤U½Æ»s

¸Ñ¤G¡G
³w©óÀx¦s®æB1¿é¤J¤@¯ë¤½¦¡
=IF(A1=$E$1,ROW(A1),"")
¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-5 23:39 ½s¿è

¦^´_ 3# t8899
1¡B¥Ñ©óBÄæ¤â°Ê¿é¤J¸ê®Æ¦³­«½Æ­Èªº¥i¯à¡A¬G©óÀx¦s®æA20¿é¤J¤@¯ë¤½¦¡ =B20+(1000-ROW())/10000¡A¦A¦V¤U½Æ»s¡A¥H»s§@»²§U¸ê®ÆÄæ¥H§Q°Ï§O­«½Æ­È¡C
2¡B3#ªþÀɤ§Àx¦s®æB3¤½¦¡«ØÄ³­×§ï¬°=SMALL($A$20:$A$25,ROW(B1))¡AÀx¦s®æ®æ¦¡³]©w¡Ð¼Æ¦r¤§¤p¼Æ¦ì¼Æ³]©w¬°¡u0¡v¡C
3¡BÀx¦s®æC3¿é¤J¤½¦¡
=INDEX($C$20:$I$25,MATCH($B3,$A$20:$A$25,0),MATCH(C$2,$C$19:$I$19,0))
¦V¥k¦V¤U½Æ»s
4¡BE3:E14½d³ò½Ð°O±o±N¨äÀx¦s®æ®æ¦¡³]©w¬°¡u¤é´Á¡v®æ¦¡
½Ð°Ñ¦Ò¡I

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD