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

[µo°Ý] ¦p¦ó¥HexcelÂù¤U©Ô¦¡¿ï³æ¿z¿ï¼Æ­È?

[µo°Ý] ¦p¦ó¥HexcelÂù¤U©Ô¦¡¿ï³æ¿z¿ï¼Æ­È?

¦p¦ó¥HexcelÂù¤U©Ô¦¡¿ï³æ¿z¿ï¼Æ­È?

½Ð°Ý¦U¤j¤j¡B°ª¤â:

¦³¤@µ§¸ê®Æ:

AÄæ BÄæ CÄæ

Taipei Apple 500
Taipei Money 20
Tainan Banana 300
TaiZhong Table 400


·Q½Ð°Ý, ¥H¤U©Ô¦¡¿ï³æ¤Í¨S¿ìªk°µ¨ì:

²Ä¤@®æ¤l ¿ïAÄæ¸ê®ÆªºTaipei¿z¿ï«á

²Ä¤G¤U©Ô¿ï³æ®æ¤l ¥u¦³Apple¤ÎMoney¸õ¥X¨Ó, ¦A¿ï¾ÜMoney«á

²Ä¤T®æ¤l¸õ¥XCÄ檺­È 20

ÁÂÁ·P®¦¡I

¦^´_ 1# la1975
AÄæ¸ê®Æ¥²¶·±Æ§Ç
¿ï¨úF1Àx¦s®æªºª¬ºA¤U©w¸q¦WºÙ
x=COUNTIF(¤u§@ªí1!$A$1:$A$4,¤u§@ªí1!$F1)
first=OFFSET(¤u§@ªí1!$B$1,MATCH(¤u§@ªí1!$F1,¤u§@ªí1!$A$1:$A$4,0)-1,,x,)
©w¸q§¹¦¨«á³]¸mF1ÅçÃÒ
²M³æ/¨Ó·½
=$A$2:$A$4
G1ÅçÃÒ
²M³æ/¨Ó·½
=first
H1¤½¦¡
=INDEX(OFFSET(first,,,,2),MATCH($G1,first,0),2)

play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

½Ð°Ýª©¥D
first=OFFSET(¤u§@ªí1!$B$1,MATCH(¤u§@ªí1!$F1,¤u§@ªí1!$A$1A$4,0)-1,,x,)

ªº³Ì«á¨º­Ó -1 ¬O¦³¤°»ò¥Î³B¶Ü?
¦]¬°§Ú§ä¤F¤@¤U¤½¦¡»¡©ú
¥i¬O³£¼g³£«Ü²³æ

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD