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

[µo°Ý] §ä¥X2ºØ±¡§Î¤U,¤é´Á³Ì¤jªº­È

[µo°Ý] §ä¥X2ºØ±¡§Î¤U,¤é´Á³Ì¤jªº­È

AÄæ¬OVender
BÄæ¬O¤é´Á
CÄæ¬OPN

¦b¤é´Áªº±Æ¦C¨S¦³¶¶§Çªº±¡§Î¤U
±¡§Î¤@¡G ¬Û¦PPN,¤é´Á³Ì¤jªº§âAÄ檺­È±a¥X¨Ó
±¡§Î¤G¡G ¬Û¦PVender¥B¬Û¦PPN,¤é´Á³Ì¤jªº§âAÄ檺­È±a¥X¨Ó

§ä¥X2ºØ±¡§Î¤U¤é´Á³Ì¤jªº­È.rar (7.52 KB)

D2=IF(MAX(($C$2:$C$22=C2)*($B$2:$B$22))=B2,A2,"")
E2=IF(MAX(($C$2:$C$22=C2)*($B$2:$B$22)*($A$2:$A$22=A2))=B2,A2,"")
¨â­Ó³£¬O¼Æ²Õ¤½¦¡
°O±o¶}¤½¦¡¦Û°Ê­pºâ

TOP

¦^´_ 2# fengetianxia

³o2²Õ¥X²{ªºµ²ªG¬O¨C­ÓÀx¦s®æ³£·|¥X²{AÄ檺­È,§¹¥þ¤£¹ï吔¡I

TOP

¦^´_ 3# PJChen

¼Æ²Õ¤½¦¡
   ­n«öctrl+shift+enter¤£¬Oª½±µ«öenter

TOP

¦^´_ 4# fengetianxia

­ì¨Ó°}¦C¤]¥s¼Æ²Õ¶Ü¡H
³o¼Ëµ²ªG´N¥¿½T¤F¡I
½Ð°Ý­n¦p¦ó§PÂ_¤°»ò®É­Ô¸Ó¥Î°}¦C¤½¦¡©O¡H

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD