¦p¦ó¦b²Ä¤@¦¸¤ñ¹ï§ä¤£¨ì®É¦Û°Ê¦A¤ñ¹ï²Ä¤G±ø¥ó®M¨ú²Å¦XªºÈ??
- ©«¤l
- 134
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 0
- §@·~¨t²Î
- WINXP
- ³nÅ骩¥»
- EXCEL 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¶³ªL
- µù¥U®É¶¡
- 2010-10-6
- ³Ì«áµn¿ý
- 2018-5-13

|
¦p¦ó¦b²Ä¤@¦¸¤ñ¹ï§ä¤£¨ì®É¦Û°Ê¦A¤ñ¹ï²Ä¤G±ø¥ó®M¨ú²Å¦XªºÈ??
¦pªþ¥ó¦³©ú²Ó¤Î²Îp¤G³øªí¡A²Îp³øªí¦C¥X®M¨ú©ú²Ó¤¤ªºÁ`¼Æ¶q¡A¦ý¦p¦ó¦b¤ñ¹ï¤£¨ì®Æ¸¹A®É¥i¦A¦Û°Ê¤ñ¹ï®ÆB¡A¨Ã±N¦P«È¤á¤Î®Æ¸¹ªº¼Æ¶q¥[Á`???
¦p¦b©ú²Ó¤¤¦³²Îp¤u§@ªí¤W¨S¦³ªº«È¤á¤Î®Æ¸¹¸ê®Æ¡A¬O§_¤S¥i³]©wÅý¨ä¼W¥[¦b²Îp³øªí³Ì«á¤@¦C¡]©Î¦¹¥u¯à¨Ï¥Î¥¨¶°¤~¯à¹F¦¨???¡^
Book2.rar (1.89 KB)
|
|
|
|
|
|
|
- ©«¤l
- 134
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 0
- §@·~¨t²Î
- WINXP
- ³nÅ骩¥»
- EXCEL 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¶³ªL
- µù¥U®É¶¡
- 2010-10-6
- ³Ì«áµn¿ý
- 2018-5-13

|
·PÁÂANGELA¤ÎHsiehª©¥Dªº¤£§[±Ð¾É¡A¸Ñ¨M¤F¤p§Ìªº¤j°ÝÃD¡A¥ý¦Û¦æºN¯Á¬Ý¬Ý¡A¦p¦³°ÝÃD¦A¦æ½Ð±Ð^^ |
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 44
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2025-2-20
               
|
¦^´_ 3# p6703
¦pªG¦³¤F°t¹ï²M³æ
C2=SUMPRODUCT((IF(COUNTIF(©ú²Ó!$B$2:$B$23,²Îp!$B2),©ú²Ó!$B$2:$B$23,©ú²Ó!$C$2:$C$23)=$B2)*(©ú²Ó!$A$2:$A$23=²Îp!$A2)*(©ú²Ó!$D$2:$D$23))
¦ý¬O¤½¦¡¨ú±o©Ò¦³°t¹ï²M³æ·|«Ü³Â·Ð¡A¥B·í¼Æ¶q¦h®É¥i¯à·|«ÜºC
ª½±µ¨Ï¥ÎVBA°õ¦æ·|¤ñ¸û«ê·í- Sub ex()
- Set d = CreateObject("Scripting.Dictionary")
- With Sheets("©ú²Ó")
- For Each a In .Range(.[A2], .[A2].End(xlDown))
- For Each b In a.Offset(, 1).Resize(, 2)
- If IsEmpty(d(a & b)) Then d(a & b) = Array(a, b, a.Offset(, 3))
- Next
- Next
- End With
- With Sheets("²Îp")
- .UsedRange.Offset(1) = ""
- .[A2].Resize(d.Count, 3) = Application.Transpose(Application.Transpose(d.items))
- End With
- End Sub
½Æ»s¥N½X |
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10

|
A2=INDEX(©ú²Ó!$A$1:$A$1000,SMALL(IF(©ú²Ó!$A$2:$A$100<>"",ROW($A$2:$A$100),999),ROW(A1)))&"" °}¦C¤½¦¡
®Æ¸¹¬Ona®Æ¸¹ÁÙ¬Ob®Æ¸¹?¥i¥ÎVLOOKUP§ì¨ú |
|
|
|
|
|
|
- ©«¤l
- 134
- ¥DÃD
- 27
- ºëµØ
- 0
- ¿n¤À
- 168
- ÂI¦W
- 0
- §@·~¨t²Î
- WINXP
- ³nÅ骩¥»
- EXCEL 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¶³ªL
- µù¥U®É¶¡
- 2010-10-6
- ³Ì«áµn¿ý
- 2018-5-13

|
·PÁÂANGELAª©¥D¡A¸Ñ¨M¤F¤p§Ìªº¤j°ÝÃD¡A¦ý½Ð°Ý¤p§Ìªº²Ä¤GÓ°ÝÃD¡A¦pªGn±N¨S¦³ªº¸ê®Æ¥[¦b²Îp©ú²Ó¤¤¡A¬O§_¥u¯à¨Ï¥Î¥¨¶°¹F¦¨??? |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10

|
=IF(SUMPRODUCT((©ú²Ó!$A$2:$A$23=A2)*(©ú²Ó!$B$2:$B$23=B2)*(©ú²Ó!$D$2:$D$23)),SUMPRODUCT((©ú²Ó!$A$2:$A$23=A2)*(©ú²Ó!$B$2:$B$23=B2)*(©ú²Ó!$D$2:$D$23)),SUMPRODUCT((©ú²Ó!$A$2:$A$23=A2)*(©ú²Ó!$C$2:$C$23=B2)*(©ú²Ó!$D$2:$D$23))) |
|
|
|
|
|
|