Çóexcel³É¼¨ÅÅÃûº¯Êý

ʱ¼ä£º2017.08.13 ·¢²¼ÈË£ºÇúÖÕÈËÔÚ
Çóexcel³É¼¨ÅÅÃûº¯Êý

Òѽâ¾öÎÊÌâ

¹È¸èÇúÖÕÈËÔÚÓû§ÔÚ2017.08.13Ìá½»Á˹ØÓÚ¡°È®Ò**æÇóexcel³É¼¨ÅÅÃûº¯Êý¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ2¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2025-03-12T21:28:47¡£

AÁÐÐÕÃû£¬BÁб¨¿¼Ñ§Ð££¨Óкܶ಻ͬѧУ£©£¬CÁгɼ¨£¬DÁÐѧ¿Æ£¨²»Í¬Ñ§¿Æ£©£¬ÇóFÁб¨¿¼Í¬Ò»Ñ§Ð£Í¬Ò»Ñ§¿ÆÅÅÃû¹«Ê½

Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£º

AÁÐÐÕÃû£¬BÁб¨¿¼Ñ§Ð££¨Óкܶ಻ͬѧУ£©£¬CÁгɼ¨£¬DÁÐѧ¿Æ£¨²»Í¬Ñ§¿Æ£©£¬ÇóFÁб¨¿¼Í¬Ò»Ñ§Ð£Í¬Ò»Ñ§¿ÆÅÅÃû¹«Ê½

ÆÚ´ýÄúµÄ´ð°¸£¬Ã»ÓÐʲô»ªÀöµÄÓïÑÔ,µ«ÊÇÎÒ¶ÔÄãµÄ¸Ðл²»»á¼õÉÙ £¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£º°ÁÏç  

132×Ö·û¹«Ê½£º

=BÃÀËɺÚÖá·ÅҹΧ²ÉͼҩÏØ2&D2&"µÚ"&SUMPRODUCT(($B$2:$B$19=B2)*($D$2:$D$19=D2)*($C$2:$C$19>C2)*(1/COUNTIFS($B$2:$B$19,B2,$D$2:$D$19,D2,$C$2:$C$19,C2)))+1&"Ãû"


µÚ2¸ö»Ø´ð

Óû§Ãû£º±¦±¦°®µöÓã  

=TEXT(IF(SUM((($B$2:$BÉÕÄïѸ$15=B2)*($D$2:$D$15=D2)*$C$2:$C$15=C2)*1)>1,SUÔçM((($B$2:$B$15=B2)*($D$2:$D$15=D2)*$C$2:$C$15>=C2)*1)-SUM((($B$2:$B$15=B2)*($D$2:$D$15=D2)*$C$×îѹÁÒ±³×èÁϲ½Àë2:$C$15=C2)*1)+1,SUM((($B$2:$B$15=B2)*($D$2:$D$15=D2)*$C$2:$C$15>=C2)*1)),"µÚ¾¿ÖÊÁ¦Ä©Áù¾ÉÒªÁ¿0[DB**M1]Ãû")

Õ³Ìù¹«Ê½ºó£¬°´Ctrl+shift+»Ø³µ