[µo°Ý] §Q¥Î¨â­Ó±ø¥ó¡A·Q§ä¥X¶i³f¤é´Á°µ¤j­È

pupai

§Ú§Q¥Î¨â­Ó±ø¥ó¡A·Q§ä¥X¶i³f¤é´Á°µ¤j­È¡A¤~¥i¥H±o¨ì§Ú¬õ¦â®Ø®Ø¤º¡A¥¿½T·Q­nªº¼Æ­È  ÁÂÁÂ!!

§Úªº¤èªkMAX(IF(AND(¶i³f!$B$2:$B$1551=¤u§@ªí1!A3,¶i³f!$A$2:$A$1551=¤u§@ªí1!$B$1,¶i³f!$D$2:$D$1551,""))
µM«á¤j¬A©·¡]{}¡^
½Ð°Ý­n¦p¦ó­×§ï?

mistery

=MAX((¶i³f!$A$2:$A$16=¤u§@ªí1!$B$1)*(¶i³f!$B$2:$B$16=¤u§@ªí1!$A2)*(¶i³f!$D$2:$D$16))
¿é¤J«á  ¥[¤TÁä

pupai

¦^´_ 2# mistery


    ±z¦n
©_©Ç§Ú¶i³f¥i¥H§ì±o¨ì¡A¥X®w«o§ì¤£¨ì?

mistery

¦^´_ 3# pupai


    ¦³«D¼Æ¦rªº¸ê®Æ¡A©Ò¥H¡@MAX   µLªk§PÂ_¤j¤p

pupai

¦^´_ 4# mistery


    ­ì¨Ó¦p¦¹ ÁÂÁÂÀ°¦£

­ã´£³¡ªL

¦^´_ 3# pupai


=MAX(IF((¥X®w!E$2:E$2936=B$1)*(¥X®w!F$2:F$2936=A2),¥X®w!A$2:A$2936))

pupai

¦^´_  pupai


=MAX(IF((¥X®w!E$2:E$2936=B$1)*(¥X®w!F$2:F$2936=A2),¥X®w!A$2:A$2936))
­ã´£³¡ªL µoªí©ó 2019-7-26 09:40

½Ð°Ýª©¥D
MAX(IF(¥X®w!E$2:E$2936=¸ê®Æ!C2,¥X®w!$A$2:$A$2936,""))
·í¤¤ªº "" ¥Î·N¬O¤°»ò

jeffrey628litw

¦^´_ 7# pupai


    "" Åã¥Ü  "ªÅ"