[µo°Ý] Excel¥Î¤½¦¡°µ¦Û°Ê¿z¿ï

andyjjliao

¤U¸ü (62.85 KB)

2012-12-25 23:21

·Q½Ð°Ý¤@¤U¦p¦ó¥Î¤½¦¡°µ¨ì»P¦Û°Ê¿z¿ï
¦p¦P¤W¶Çªº¹ÏÀɤ¤¡A¦bE2¿é¤J­n¬dªºÃþ§OC¡A
¦bF/G/H¤T­ÓÄæ¦ì§Y·|¦Û°Ê¦C¥X©Ò¦³Ãþ§O¬°Cªº¸ê®Æ
¤£»Ý°µ¥ô¦ó¹BºâOR±Æ§Ç¡A¥u­n¦C¥X¸ê®Æ§Y¥i

Google¬d¤F«Ü¤[¡A³£¨S¿ìªk§ä¨ì¦X¾Aªº¤è¦¡
¥uª¾¹D¥ÎINDEX¤ÎMATCH°µ°}¦C¤½¦¡¥i¥H¹F¨ì³o­Ó®ÄªG
¤£¹L¦Û¤v¸Õ³£¬O¥¢±Ñ¡A¥u¦n¤W¨Ó¨D±Ð©ó¦U¦ì¥ý¶i
¤u§@¤W¦³«æ»Ý¡A¥ýÁ¹L±zªºÀ°¦£

hcm19522

http://blog.xuite.net/hcm19522/twblog/351077405

imingho

¦^´_ 2# Hsieh
ª©¥D±z¦n,
       §Ú§@¦n®É¡A­n¦A¥h½s¿è¬d¸ß®É¡A·|¥X²{¦p¤Uµe­±¡C

¤U¸ü (51.28 KB)

2015-5-27 22:01

¤U¸ü (37.37 KB)

2015-5-27 22:01

samwang

¦^´_ 2# Hsieh
ª©¥D
½Ð°Ý¦pªG¬O¦h±ø¥ó¤]¥i¥H¶Ü?
¨Ò¦p: µ¥©óA±ø¥ó´N>>Åã¥Ü¼Æ­È
           ©Î¦b¥[¥t¤@­ÓB±ø¥ó>>Åã¥Ü¼Æ­È

starry1314

¦^´_ 4# Hsieh

ª©¥D½Ð°Ý¦¹¨ç¼Æ¦pªG­n§ó§ïÄæ¦ìªº¸ÜÁÙ¦³­þÃä»Ý­nÅÜ°Ê©O?
=IF(ROW($AK4)>COUNTIF(OFFSET($AK$4,1,,COUNTA($AK4:$AK30)-1,),$A$6),"",INDEX(OFFSET($AK$4,,,COUNTA($AK4:$AK30),3),SMALL(IF(OFFSET($AK$4,1,,COUNTA($AK4:$AK30)-1,)=$A$6,ROW(OFFSET($AK$4,1,,COUNTA($AK4:$AK30)-1,)),""),ROW($AK4)),COLUMN(AK$4)))
   

«ç»ò§ï³£¬O¥X²{#REF
A6=«ü©w·j´MªºÃþ§O¦WºÙ   

AK4:AK30= ¸ê®Æ½d³ò
AK4=¼ÐÃD

Hsieh

¦^´_ 5# shootingstar

ªí®æ¿ï¶µ¤¤¤Ä¿ï¨t²Îªí®æ

¤U¸ü (44.04 KB)

2012-12-26 16:23

shootingstar

¦^´_ 2# Hsieh


½Ð±ÐHeishª©¥D¡A¬°¤°»ò§Ú¦b¾Þ§@¨ì¿ï¨ú¬¡­¶Ã¯-->¸ê®Æ®w¦WºÙ®É¡A·|¥X²{"¦¹¸ê®Æ¨Ó·½¤¤¨Ã¥¼¦s¦b¥i¨Ï¥Îªºªí®æ"¡HÁÂÁ¡C

Hsieh

¦^´_ 3# andyjjliao

°}¦C¤½¦¡¤èªk½×¾Â¤¤¦³«Ü¦h¡A¥i¦hª¦¤å
¤½¦¡¤èªkªº³Ì¤j¯ÊÂI¬O¡A·í¸ê®Æ¶q¤j®É¡Aµ{¦¡·|Åܪº½wºC
¦Ó¥B¦]¬°ºI¨ú¸ê®Æ¶q¤£½T©w¡A¤½¦¡¤U©Ôªº¦ì¸m¥²¶·½Õ¾ã
F2°}¦C¤½¦¡
=IF(ROW($A1)>COUNTIF(OFFSET($A$1,1,,COUNTA($A:$A)-1,),$E$2),"",INDEX(OFFSET($A$1,,,COUNTA($A:$A),3),SMALL(IF(OFFSET($A$1,1,,COUNTA($A:$A)-1,)=$E$2,ROW(OFFSET($A$1,1,,COUNTA($A:$A)-1,)),""),ROW($A1)),COLUMN(A$1)))
¦V¥k¦V¤U½Æ»s

andyjjliao

·PÁª©¤jªº¦^ÂÐ
¤£¹L§ÚÁÙ¬OÆZ·Qª¾¹D¯à§_¨Ï¥Îindex¤Îmatch¨Ó¹F¨ì¬Û¦Pªº®ÄªG©O¡H

Hsieh

¦^´_ 1# andyjjliao

¤U¸ü (1.03 MB)

2012-12-25 23:44