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

landylin

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

TEST1.rar (2.44 KB)

¤U¸ü¦¸¼Æ: 15

2012-5-27 19:09

register313

¦^´_ 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)

Hsieh

¦^´_ 1# landylin

P6=IF(SUMPRODUCT((MONTH($I6:$M6)=MONTH(P$4))*1)=0,"",OFFSET($H6,,-SUMPRODUCT(($I6:$M6>=P$4)*1))&"")

landylin

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

TEST2.rar (2.47 KB)

¤U¸ü¦¸¼Æ: 7

2012-5-28 01:00

Hsieh

¦^´_ 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)
¸Õ¸Õ¬Ý

ANGELA

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

landylin

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

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

TEST2A.rar (2.79 KB)

¤U¸ü¦¸¼Æ: 12

2012-5-28 14:07

Hsieh

¦^´_ 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))

landylin

Hsieh  ·PÁ±z !!