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

[µo°Ý] ¸ê®Æªí°ÝÃD

[µo°Ý] ¸ê®Æªí°ÝÃD

½Ð°Ý¤@¤U¦Ñ®v

§Ú¦³¤@­Ó¸ê®Æªí¡A·ísheet1 ·s¼W¤@¦C©Î§R°£®Ésheet2¤Îsheet3§Æ±æ¥i¥H¦P®É°Ê§@¡A
¦bsheet1·s¼W¸ê®Æ®É¦bsheet2©Îsheet3ªº³Ì«á¤@¦C
­Y¦bsheet1§R°£®Ésheet2©Îsheet3¦Û°Ê¤W²¾¤@¦C¸Éº¡

¸ê®Æªí.rar (1.91 KB)

CELL("filename",!$A$1)ªºµª®×¬Ý¤@¤U¦A¥h¤F¸ÑFIND¨ç¼Æªº¥Îªk´Nª¾¹D¬°¤°»ò­n¥Î"["
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

½Ð°Ý¦U¦ì¦Ñ®v Hsieh¦Ñ®v ªþ¥ó¤½¦¡ =IF($A2="","",INDIRECT("Sheet1!R"&SMALL(IF(Sheet1!$B$2:$B$65536=sh,ROW($2:$65536),""),°]°È²Õ!$A2)&"C[-1]",0))   ¨ä¤¤ Sheet1!R ¤°»ò·N«ä¡A¥t¥~©w¸qùØ=MID(CELL("filename",!$A$1),FIND("]",CELL("filename",!$A$1))+1,255) ¬°¤°»ò¥Î "]" ¬O¤°»ò·N«ä

TOP

©w¸q¦WºÙ

¨ì
´¡¤J>¦WºÙ>©w¸q>©w¸q¦WºÙ
¬Ý¬Ý¬O«ç»ò¤@¦^¨Æ
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦Ñ®v½Ð°Ý¤@¤UIF(ROW($A1)>COUNTIF(Sheet1!$BB,sh),"",ROW($A1)) ¤¤ªºsh¬O§@¤°»ò¥Îªº

TOP

ÁÂÁ¦Ѯvªº«ü¾É¡A¬ã¨s¤@¤U¡A¦³°ÝÃD ¦A³Â·Ð¦U¦ì¦Ñ®v

TOP

Äæ¦ì¦Û¤v¬Ýindirect¨ç¼Æ»¡©ú¥h½Õ¾ã
¸ê®Æªí1.rar (7.5 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ¦Ѯv¡A§Ú§ï¦n«á¥i¥Î¤F¡A¦ý§R°£sheet1¨ä¤¤¤@¦C«á°]°È³¡´N¥þ³¡¥X²{¤FN/A¤F¡A§Ú¨ºùØ¿ù¤F¶Ü

TOP

­n§â°]°È²Õ±qsheet1©î¥X¨Ó,­n¥Îindex
B2={INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$B$2:$B$50="°]°È²Õ",ROW($2:$50),1000),ROW(A1)))&""}
°}¦C¤½¦¡
A2 =IF(B2="","",ROW(A1))
¨ä¥Lªº¸ò¾Ú­nINDEXªº¬Û¹ïÄæ¦ì­×§ï§Y¥i.

TOP

ÁÂÁÂANGELA ¦Ñ®v¥Î¤ß¨}­W¡AÁöµM¤£¬O«ÜÀ´¡A¤@ª½§V¤O¾Ç²ß¤¤¡A²{¦b¦³­Ó©µ¦ùªº°ÝÃD¬O­Y§Ú¥[¤W³¡ªù¤Î¶µ¦¸«á(¦pªþ¥ó)¡A¬ã¨s¤F¤@­Ó¦­¤WÁÙ¬O¤£·|¡A³Â·Ð¦Ñ®v«ü¾É¤F

¸ê®Æªí1.rar (2.18 KB)

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD