ªð¦^¦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)

sheet2!a2=IF(INDIRECT("Sheet1!A"&ROW(A2))="","",INDIRECT("Sheet1!A"&ROW(A2)))

TOP

ÁÂÁÂANGELA ¦Ñ®v«ü¾É¡A¦ý¥u¦³©m¦WÄæ¥i¥H¡AµLªk¾ã¦C¤@°_ÅÜ°Ê¡A§Ú¸ÕµÛ§ï=IF(INDIRECT("Sheet1!A"&ROW(C2))="","",INDIRECT("Sheet1!A"&ROW(C2))) ¦bsheet2ªºb2Äæ¤]¤£¦æ¡A³Â·Ð¦Ñ®v¤F

TOP

¦Ñ®v¤£¦n·N«ä¡A¥i¥H¤F¡A¬O§Ú¨S¬Ý²M·¡¤Ö§ï¤Fsheet1!C¡A¾Ç¥Íª¾¿ù¤F¡AÁÂÁÂ

TOP

¥u¦³¤F¸Ñ¤½¦¡ªº¹B§@¤è¦¡«á,¤½¦¡¤~·|¬°§A©Ò¥Î,¤£¦C¥X©Ò¦³¸Ñµª,¥Øªº¤]¦b³o¸Ì.®¥³ß§A.¦h¤F¸Ñ¤F¤@­Ó¤½¦¡.

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

­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

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

TOP

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

TOP

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

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD