·s¤â¡A¦³EXCEL°ÝÃD¤@°Ý¡A½Ð±Ð¡A½Ð±Ð

lesaux001

²Ä¤@­¶:AÄ欰¾­û¤u¸¹¡ABÄ欰¾­û©m¦W¡ACÄ欰§ó¥÷¡ACÄæ·|¦³©ñ°²¡AA¡AA+3¡AB¡A C¡AC+3§ó¥÷¡A§Ú·Q«Y²Ä¤G­¶¤º¸ò¾Ú²Ä¤@­¶§ó¥÷¦A¤À¤T³¡¥÷¡A(²Ä¤@³¡)¥÷¬OA¤ÎA+3¤ÎE§ó¡A¤À¾¯Å¡A©m¦W¡A§ó¥÷¡A(²Ä¤G³¡)¥÷¬OB§ó¡A¤À¾¯Å¡A©m¦W¡A§ó¥÷ ; (²Ä¤T³¡)¥÷¬OC¤ÎC+3¤ÎE§ó¡A¤À¾¯Å¡A©m¦W¡A§ó¥÷ ; (²Ä¥|³¡)¥÷¬O©ñ°²RD / OF¡C
§Ú¬OEXCELªì­ô¡A½ÐÀ°À°¦£¡C §ó¥÷.rar (13.26 KB)

§ó¥÷
¤U¸ü¦¸¼Æ: 24

2016-7-12 18:54

hcm19522

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

lesaux001

¤£©ú¥Õ¡A½Ð½ç±Ð

ML089

¦^´_ 1# lesaux001

D6°}¦C¿é¤J¤½¦¡¡A¬° §óªí ªº¦ì¸m
{ =SMALL(IF(ISNUMBER(0/(FIND(§óªí!$D$1:$D$99,LOOKUP(1,0/(A$5:A5="¾­û¤u¸¹"),A$3:A3))*FIND(§óªí!$A$1:$A$99,LOOKUP(1,0/(A$5:A5="¾­û¤u¸¹"),A$4:A4))*(§óªí!$A$1:$A$99<>""))),ROW($1:$99),4^8),ROW()-LOOKUP(1,0/(A$1:A5="¾­û¤u¸¹"),ROW($1:5))) }
   
¨ä¥LA6¡BB6¡BC6¨Ï¥Î INDEX¨Ó³B²z

ML089

±µ #4 ¼Ó D6¤½¦¡

A6 =INDEX(OFFSET(§óªí!$B:$B,,MOD(COLUMN()-1,4)),OFFSET($D6,,INT(COLUMN()/4)*4))&""

µM«á½Æ¦Ü¨ì¨C¤@®æ

lesaux001

­ø¦n·N«ä¡A¦hÁÂML089À°§U¡A¦ý§Ú²Ä¤G­¶¤º¡A»Ý¤À¶}A§ó / A+3§ó / E§ó¡AB§ó¡AC§ó / C+3§ó¡ARD / OF©ó¤£¦PÄæªí¥Ü!

ML089

¦^´_ 6# lesaux001

´ú¸Õ«á§â¤£¹ïªº¦a¤è»¡©ú¤@¤U¡A³Ì¦n§â­nªºµ²ªG¼Ð¤W¥h¤ñ¸û®e©ö¤ñ¹ï¡C
»¡¹ê¦b§Aªº°ÝÃD§Ú¬O²q¬Ý¬Ý¨Ó°µªº¡C

lesaux001

ÁÂÁ¡A§Ú¦^®a¦A²Õ´¤U¥ý