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

¦WºÙ½d³ò°ÊºA­×§ï°ÝÃD Âù¼h¤U©Ô¿ï³æ

¦WºÙ½d³ò°ÊºA­×§ï°ÝÃD Âù¼h¤U©Ô¿ï³æ

¦U¦ì¤j¤j¡G
¤p§Ì¦³¤G­Ó°ÝÃD·Q½Ð±Ð
¤p§Ì¦³¹ï¤@­Ó¦WºÙ§@¤U½d³òªº©wij¬°¡G=OFFSET(¤U©Ô¿ï³æ!$A$2,,,COUNTA(¤U©Ô¿ï³æ!$A:$A)-1,1)¡A­Y¬O§Úªº³sÄò¸ê®Æ¤º¦³¤@­Ó¬OªÅ®æ¡A«h³o­Ó¦¡¤l¡AµLªk§¹¾ã©Ô¨ì³Ì«á¤@®æ¦³¸ê®Æªº³¡¥÷¡A©Ò¥H¤p§Ì¦³¤°»ò¤èªk¡A¥i¥H±oª¾³Ì«á¤@®æ¦³¸ê®Æªº¦ì¸m©O¡H
¥t¤@­Ó°ÝÃD¬O¡A³æ¥u§@¤@¼hªº¤U©Ô¿ï¶µ®É¡A¤p§Ì¥i¥H¨Ï¥Î New Part 1.zip (14.6 KB) ¤W­z¤½¥q§¹¾ãªº¨ú±o¥¿½T¦ì¸m¡A¦ý¬O­Y§ï¦¨Âù¼h¡A«hµLªk¥¿½T¨ú±o¡A»Ý­n§â©wij¦WºÙ¡A§ï¦¨¹ê»Úªº¦ì§}½d³ò¤~¦æ¡A³o­Ó¥i¦³¤èªk¥i¸Ñ¡H

ÀɮסG
clio

©w¸q¦WºÙ:
1) xRng¡G=OFFSET(¤U©Ô¿ï³æ!$A$1,,MATCH($E2,¤U©Ô¿ï³æ!$1:$1,)-1)
2) xList¡G=OFFSET(xRng,1,,MATCH("ùÜ",OFFSET(xRng,,,9999))-1)

ÅçÃÒ>²M³æ: =xList

Xl0000244.rar (8.59 KB)

TOP

¦^´_ 2# ­ã´£³¡ªL
·PÁ­㴣¤j¤j¡G
§¹¥þ¸Ñ¨M¤F¤p§Ìªº§xÃø¡A¤p§Ì¥i¥H¦A½Ð±Ð¤G­Ó°ÝÃD¶Ü¡H
¤@¡B­ì¥ýªº³]©w¦b¦WºÙ³]©wªº¡iApproval¡jªº¤½¦¡¡i=OFFSET(¤U©Ô¿ï³æ!$A$2,,,COUNTA(¤U©Ô¿ï³æ!$A:$A)-1,1)¡j¡A­Y¬OÂର¹ê»Ú«ü©wªº¦ì§}½d³ò¡A´N¯à¥¿±`°Ê§@¡A¦ý¬O¥Î¨º­Ó¤½¦¡´N·|¿ù¡A³o­Ó­ì¦]¤p§ÌÁÙ¬O¤£²M·¡¡A·Q§â³o­Ó°ÝÃD§ËÀ´¡A§K±o¥H«áÁÙ¬O¤@ª¾¥b¸Ñªº¡C
¤G¡BMATCH("ùÜ",OFFSET(xRng,,,9999))¡A³o­Ó"ùÜ"¬O¥i¥H§ä¨ì¸Ó«á¤@­Ó¦³¸ê®Æªº¦ì¸m¹ï§a
ÁÙ­n¦A³Â·Ð­ã´£¤j¤j¦Aªá¤@¤U®É¶¡¬°¤p§Ì§Ú¸Ñ´b¡A·PÁ±z¡C¯¬±z¸U¨Æ¶¶¤ß
clio

TOP

¦^´_ 3# clio


1) INDIRECT µLªk¤Þ¥Î¥Ñ¤½¦¡²£¥Íªº©w¸q¦WºÙ
2) MATCH("ùÜ",~~) §ä¬d[¤å¦r]³Ì«á¤@µ§ªº¦ì¸m, ­Y¬O¤å¦r¤Î¼Æ­È²V¦X´N¤£¾A¥Î

TOP

¦^´_ 4# ­ã´£³¡ªL
·PÁ­㴣¤j¤jªº¦^ÂСA³o¼Ë§Ú´N²M·¡¤F¡A¸U¤À·PÁ±z¡C
clio

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD