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

[µo°Ý] ¦b¤@­Ó½d³ò¤º¤£¥X²{¬Û¦P­Èªº¤½¦¡¬°¦ó?

[µo°Ý] ¦b¤@­Ó½d³ò¤º¤£¥X²{¬Û¦P­Èªº¤½¦¡¬°¦ó?

¦p¹Ï

Book1.png
2015-11-27 08:23


Book1.rar (7.53 KB)

B3:B5{=INDEX(H:H,LARGE(IF(COUNTIF(B$1:B1,H$1:H$5)=0,ROW(H$1:H$5)),RANDBETWEEN(1,5-ROW(A1))))

TOP

B3:B5{=INDEX(H:H,LARGE(IF(COUNTIF(B$1:B1,H$1:H$5)=0,ROW(H$1:H$5)),RANDBETWEEN(1,5-ROW(A1))))
hcm19522 µoªí©ó 2015-11-27 10:02



    ¦n¹³¬OÀH¾÷¥X²{¡A·|¦³­«ÂЭÈ

TOP

B2:B5 °}¦C

TOP

B2:B???(¹w¥ý¤U©Ô)=IF(ROW(A1)>COUNTA(H:H)-1,"",OFFSET(H$1,MOD(MATCH(B$1,H:H,)+ROW(A1)-1,COUNTA(H:H)),))
¶¶§Ç¨ú¸ê®Æ ,¨ì³Ì«áÄæ ,±qÀY¨ú¸ê®Æ ,COUNTA(H:H)ªí¥Ü«öHÄæ¸ê®Æ¼Æ¥Ø ,¦Û°Ê§PÂ_ ,HÄæ¸ê®Æ¥i¼W´î

TOP

B2:B???(¹w¥ý¤U©Ô)=IF(ROW(A1)>COUNTA(H:H)-1,"",OFFSET(H$1,MOD(MATCH(B$1,H:H,)+ROW(A1)-1,COUNTA(H:H)), ...
hcm19522 µoªí©ó 2015-11-27 18:21



    ÁÂÁ¡I¥¿¸Ñ

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD