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

[µo°Ý] ½Ð°Ý ¸ê®ÆÂà¦Vªº°ÝÃD

[µo°Ý] ½Ð°Ý ¸ê®ÆÂà¦Vªº°ÝÃD

¦b¤u§@¤W硑¨ì¤@­Ó°ÝÃD¬O¦p¦ó±N¸ê®ÆÂà¦V. ¦]¸ê®Æ¶q¤j, ¦]¦¹¤£¤Ó·Q¥Î¿ï¾Ü©Ê¶K¤W,Âà¸m¨Ó°µ.

¥ªÃ䪺ªí®æ¤¤"1" ¦³A, B, D, E. "2" ¦³B, C, D, G, H. ¦ý¬OÁa¦V. §Ú­nÅܦ¨Ù¶¦V.³o¼Ëªº¸ê®Æ«Ü¦h, ©Ò¥H­n¥Î¦Û°ÊªºÂà.

½Ð¦U¦ì¤j¤jÀ°¦£¬Ý¤@¤U¬O§_¦³¤èªk¥i¥H¦Û°Ê²£¥Í.

¥»©«³Ì«á¥Ñ PD961A ©ó 2010-6-30 13:23 ½s¿è

¦^´_ 1# alanw33


   

TOP

E4=1,E5=2
F4=IF(COUNTIF($B:$B,$E4)>=COLUMN(A1),OFFSET($B$1,MATCH($E4,$B$3:$B$20,)+COLUMN(A1),1),"")
¦V¥k¦V¤UCOPY

TOP

¤@©w­n¤½¦¡¶Ü?³t«×¦P·|«ÜºC³á

E4 ¤½¦¡©¹¤U¬I

{=INDEX(B:B,MIN(IF(COUNTIF(E$3:E3,B$2:B$15),4^8,ROW($2:$15))))&""}

F4 ¤½¦¡©¹¥k¤Î©¹¤U¬I

{=IF($E4="","",INDEX($C:$C,SMALL(IF($B$2:$B$20=--$E4,ROW(2:20),4^8),COLUMN(A$1)))&"")}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

·PÁ¦U¦ì¤j¤j..²Ä¤@¦¸¨Ó³o¸Ìµo袩..¨S·Q¨ì¦^ÂЪº³t«×Åý¤H·P°Ê..¥H«á­n±`¨ÓÉèÄ_¤F

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD