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

[µo°Ý] ½Ð°Ý­n¨Ï¥Î¤°»ò¨ç¼Æ¤~¯à­pºâ¥X³f¼Æ¶q

¥»©«³Ì«á¥Ñ p212 ©ó 2014-8-18 09:02 ½s¿è

¦^´_ 1# guesspro 1¡B
1¡B­ì©l¸ê®Æ³¡¤À©w¸q¦WºÙ
(1)©w¸q¡u²£«~±ø½X¡v¡A¡u°Ñ·Ó¨ì¡v¿é¤J=OFFSET(¤u§@ªí1!$B$3,,,COUNTA(¤u§@ªí1!$B:$B)-1)
(2)©w¸q¡u®Ä´Á¡v¡A¡u°Ñ·Ó¨ì¡v¿é¤J=OFFSET(¤u§@ªí1!$C$3,,,COUNTA(¤u§@ªí1!$C:$C)-1)
(3)©w¸q¡u«~¦W¡v¡A¡u°Ñ·Ó¨ì¡v¿é¤J=OFFSET(¤u§@ªí1!$D$3,,,COUNTA(¤u§@ªí1!$D:$D)-1)
¨Ï¥Î©w¸q¦WºÙ¥Î·N¦b©ó¦]À³­ì©l¸ê®Æ¥i¼W¥[µ§¼Æ
2¡B»Ý­nªº¸ê®Æ³¡¤À
(1)Àx¦s®æF3¿é¤J°}¦C¤½¦¡(½Ð¥HCtrl+Shift+Enter¿é¤J¤½¦¡)
=IFERROR(INDEX(²£«~±ø½X,MATCH(0,COUNTIF($F$2:F2,²£«~±ø½X),0)),"")
(2)Àx¦s®æG3¿é¤J¤@¯ë¤½¦¡
=IF(F3="","",INDEX(®Ä´Á,MATCH(F3,²£«~±ø½X,0)))
(3)Àx¦s®æH3¿é¤J¤@¯ë¤½¦¡
=IF(F3="","",INDEX(«~¦W,MATCH(F3,²£«~±ø½X,0)))
(4)Àx¦s®æI3¿é¤J¤@¯ë¤½¦¡
=IF(F3="","",COUNTIF(²£«~±ø½X,F3))
½Ð°Ñ¦Ò¡I
µù¡G¤W¦C°²³]¤u§@ªí¦WºÙ¬°¡u¤u§@ªí1¡v¡A­Y¤u§@ªí¦WºÙ¬°¡u²£«~¡v¡A«h¡u¤u§@ªí1!¡v(ÂŦⳡ¤À)½Ð¦Û¦æ´À´«¬°¡u²£«~!¡v)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-8-18 11:41 ½s¿è

¦^´_ 3# guesspro
¥i¥H¤W¶Ç½d¨ÒÀÉ¡H¡]¬Ù¥h³yÀɳ·С^
ÁÂÁ¡I

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD