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

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

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

§Ú§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¦ó­×§ï?

¶i³f¤é´Á.rar (8.45 KB)

¥»©«³Ì«á¥Ñ mistery ©ó 2019-7-24 16:15 ½s¿è

=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Áä

¶i³f¤é´Á.zip (9.41 KB)

TOP

¦^´_ 2# mistery


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

1080725.rar (83.83 KB)

TOP

¦^´_ 3# pupai


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

1.png (19.58 KB)

1.png

TOP

¦^´_ 4# mistery


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

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-7-26 09:42 ½s¿è

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

TOP

¦^´_  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¤°»ò

TOP

¦^´_ 7# pupai


    "" Åã¥Ü  "ªÅ"

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD