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

[µo°Ý] ²£¥X¤é´Á¸ê®Æ¤ñ¹ï

[µo°Ý] ²£¥X¤é´Á¸ê®Æ¤ñ¹ï

¦U¦ì¤j¥´±z¦n
«æ»Ý·Ð½Ð¨ó§U ,¦]­n­pºâWIP¦b»s«~¥Í²£¥¼§¹¦¨ ,¹w¦ô¨C¤ë©³°±¯d¦b¨º­Ó¯¸§O ,
¦³´£¨Ñªþ¥ó,­n¦p¦óÂà´«¦¨¤½¦¡,  ÁÂÁÂ!

TEST1.rar (2.44 KB)

¥»©«³Ì«á¥Ñ register313 ©ó 2012-5-27 21:11 ½s¿è

¦^´_ 1# landylin

P6=IF(7-SUM(IF($I6:$N6>P$4,1,0))=7,"",IF(7-SUM(IF($I6:$N6>P$4,1,0))=6,$G6,OFFSET($C$6:$F$6,,6-SUM(IF($I6:$N6>P$4,1,0)))))
©Î
P6=IF(ISERROR(MATCH(MONTH(P$4)+1,MONTH($I6:$N6),0)),"",IF(MATCH(MONTH(P$4)+1,MONTH($I6:$N6),0)=6,$G6,INDEX($C6:$G6,,MATCH(MONTH(P$4)+1,MONTH($I6:$N6),0))))

2ªÌ§¡¬°°}¦C¤½¦¡(¿é¤J¦n¤½¦¡­n«öCTRL+SHIFT+ENTER)

TOP

¦^´_ 1# landylin

P6=IF(SUMPRODUCT((MONTH($I6:$M6)=MONTH(P$4))*1)=0,"",OFFSET($H6,,-SUMPRODUCT(($I6:$M6>=P$4)*1))&"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ¦U¦ì¤j¤j¨ó§U,
®M¥Î¤½¦¡«á,¦pªG¦³ªÅ¥Õ,½Ð°Ý¤½¦¡­n¦p¦ó­×§ï?
´£¨Ñªþ¥ó ,¦A³Â·Ð¦U¦ì¤j¤j,ÁÂÁÂ@

TEST2.rar (2.47 KB)

TEST2.rar (2.47 KB)

TOP

¦^´_ 4# landylin

O6¬°¦ó·|¬OD?
¨ÌÃD·NÀ³¬O§ä¥X¤j©óµ¥©ó¨C¤ë³Ì«á¤@¤Ñªº³Ì¤p­È¥h¹ïÀ³¤u¥O¥¼§¹¤u»sµ{§Ç
O6°}¦C¤½¦¡
=LOOKUP(MIN(IF($I6:$M6>=O$4,$I6:$M6,"")),$I6:$M6,$C6:$G6)
¸Õ¸Õ¬Ý
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

o6=INDEX($C6:$H6,IF(ISERROR(MATCH(1=1,$I6:$M6>=O$4,)),6,MATCH(1=1,$I6:$M6>=O$4,)))&""
°}¨Ò¤½¦¡

TOP

sorry , O6¬°¦ó·|¬OD?  ¬O§Ú¼Ð¥Ü¿ù»~ ,ÁÂÁ±zªº´£¿ô ,
ÁÂÁ¦U¦ì¤j¤jªº¨ó§U ,

½Ð°Ý Hsieh ¤j¤j:
®M¥Î±zªº¤½¦¡ ,¦p¨ì§¹¤u¤é¦³ªÅ¥Õªº , ·|¥X²{#N/A ??

TEST2A.rar (2.79 KB)

TOP

¦^´_ 7# landylin

O6°}¦C¤½¦¡
=IF(SUMPRODUCT(($I6:$M6>=O$4)*1)=0,"",LOOKUP(MIN(IF($I6:$M6>=O$4,$I6:$M6,"")),$I6:$M6,$C6:$G6))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh  ·PÁ±z !!

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD