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

¦Pexcel «ö¯S©wÄæ¦ìªº­È¡A¨M©w­nÅã¥Ü¦b­þ­ÓSheet¤W

¦Pexcel «ö¯S©wÄæ¦ìªº­È¡A¨M©w­nÅã¥Ü¦b­þ­ÓSheet¤W

hi.. §Ú³o¸Ì¦³­Ó°ÝÃD¡C
§Úªºexcel ¦³3­Ósheet
1¡Dsheet name: summary
2¡DSheet Name: open
3¡DSheet Name:Close

§Ú¦bSummary ¸Ì©ñ¤F§Ú©Ò¦³ªº¤u§@¨Æ¶µ¡A§ÚÁ`¦@¦³10­ÓÄæ¦ì¡A¨ä¤¤¤@­ÓÄæ¦ì¥sª¬ºA¡A·í§Úªºª¬ºA¬Oopenªº®É­Ô¡A§ÚÂI¿ïSheet Name:Open §Ú´N¯à¬Ý¨ì©Ò¦³ª¬ºA¬Oopenªº¸ê®Æ¡AÂI¿ïSheet Name:Close¤]¬O¤@¼Ëªºµ²ªG¡A¥u­n§Ú¦bSummary¨º¤@­¶ªºª¬ºAÄ榳ÅܤơA¥u­n§Ú¤Á´«¨ìOpen©Î¬OClose­¶¡A´N¯à¥ß§Y¤ÏÀ³¡A½Ð°Ý³o­ÓExcel­n«ç»ò»s°µ©O?

°²³]summaryªºCÄæ¦ì¥sª¬ºA
OPENªºA2=INDEX(summary!A:A,SMALL(IF(summary!$C$1:$C$900="OPEN",ROW($1:$900),999),ROW(1:1)))&""
CLOSEªºA2=INDEX(summary!A:A,SMALL(IF(summary!$C$1:$C$900="CLOSE",ROW($1:$900),999),ROW(1:1)))&""
¥H¤W³£¬O°}¦C¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD