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

[µo°Ý] ½Ð±Ð°ê§Oµ§¼Æ¤§­pºâ

[µo°Ý] ½Ð±Ð°ê§Oµ§¼Æ¤§­pºâ

¥»©«³Ì«á¥Ñ °¶ÔÐ ©ó 2010-10-1 05:01 ½s¿è

§Ú¦³¤W¤dµ§¸ê®Æ,¨C¤@¦Cºâ¤@µ§¸ê®Æ
¦bAÄæ[°ê§O]Àx¦s®æ¤¤,¥Ñ¤@­Ó©Î¼Æ­Ó¦r¦ê²Õ¦¨,¤¤¶¡¥H¤À¸¹¹j¶}
¨C­ÓÀx¦s®æ¤¤¤§°ê®a,¤£ºÞ¥X²{ªº¦ì¸m,©ÎªÌ¬O§_­«½Æ,¥u­n¦³¥X²{¶È­p¼Æ1¦¸

¨Ò¦p
°ê§O
Wales
USA; USA; USA; USA; USA
USA; USA; Taiwan; USA
USA; USA; Italy; USA; USA
USA; Spain
USA; South Korea
Switzerland; Switzerland; Belgium; Italy; Belgium; Italy

«h
°ê®a¡@¡@¡@¡@¡@¡@¡@¡@¡@µ§¼Æ
Wales¡@¡@¡@¡@¡@¡@¡@¡@1
USA¡@¡@¡@¡@¡@¡@¡@¡@¡@5
Taiwan¡@¡@¡@¡@¡@¡@ ¡@1
Italy¡@¡@¡@¡@¡@¡@¡@¡@  2
Spain¡@¡@¡@¡@¡@¡@¡@¡@1
South Korea¡@¡@¡@¡@ 1
Switzerland¡@¡@¡@¡@  1
Belgium¡@¡@¡@¡@¡@  ¡@1

¥Ø«e°ÝÃD¬O¸Ñ¨M¤F,¤£¹Lı±o¦Û¤vªº¤èªk¤£¬O«Ü¦³®Ä²v,©Ò¥H,·Q½Ð±Ð¦U¦ì¦³¨S¦³¤°»ò¸û¦³®Ä²vªº§Þ¥©,ÁÂÁÂ!

991001.zip (11.76 KB)

°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-10-1 08:08 ½s¿è

E2=SUMPRODUCT(ISNUMBER(FIND($D2,OFFSET($A$1,,,COUNTA($A:$A),)))*1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¬Û·í±jªº¤½¦¡¡I
¤£ª¾¹D¤W¤dµ§®É³t«×¦p¦ó¡H

TOP

¦^´_ 3# oobird


    À³¸Ó«ÜºG
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ °¶ÔÐ ©ó 2010-10-2 00:21 ½s¿è

ÁÂÁÂ[Hsieh]ª©¥D
§Ú³B²z¤C¤d¦hµ§ªº¸ê®Æ,¤£¨ì´X¬íÄÁ´NOK¤F
¯uªº°ª®Ä²v!!

²{¦b¦³¦h¤@ºØ¤èªk¥i¥HÅý§Ú°µ¬°½T»{¤§¥Î,ÁÂÁÂ!
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

¦^´_ 5# °¶ÔÐ

¯à¦³³o»ò¦nªº³t«×¶Ü?
³oÀ³¸Ó¬O¥u§PÂ_FIND¦r¦ê¬O§_¦s¦b
©Ò¥H¨C­Ó°ê¦W¥u»Ý°µ7¤d¦h¦¸§PÂ_
¥i¨£¤º«Ø°}¦C¨ç¼Æ¹BºâÀ³¸ÓÂõۤñVBA§ó§C¶¥ªº»y¨¥
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦¹¤½¦¡·|±N[Serbia Monteneg]ºâ¦b[Serbia]¤º¥B[North Ireland]ºâ¦b[Ireland]¤º,¦P®É[Serbia Monteneg]»P[North Ireland]¥ç·|¦A¦Û¤v­p¼Æ¤@¦¸,Åܦ¨·|¦³­«½Æ­p¼Æªº°ÝÃD
¤£ª¾­n¦p¦ó¸Ñ¨M?ÁÂÁÂ!

¨Ò¦p
North Ireland; North Ireland
Ireland; Ireland
Ireland
Germany; Ireland
Canada; North Ireland; Peoples R China

µ²ªG
Ireland  5
North Ireland   2
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

¦^´_ 7# °¶ÔÐ
Function Word_Count(Word As String, WordRange As Range) As Integer
    Dim i As Integer, E As Range, A
    For Each E In WordRange
        For Each A In Split(E, ";")
            If Trim(A) = Trim(Word) Then i = i + 1: Exit For
        Next
    Next
    Word_Count = i
End Function

TOP

=SUMPRODUCT(ISNUMBER(FIND($D2,OFFSET($A$1,,,COUNTA($A:$A),)))*1)-(SUMPRODUCT(ISNUMBER(FIND($D2,OFFSET($D$1,,,COUNTA($D:$D),)))*1)-1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# GBKEE

ÁÂÁÂ[GBKEE]ª©¥D,¸Ñ¨M¤F[Serbia]­«½Æ­p¼Æ[Serbia Monteneg]»P[Ireland]­«½Æ­p¼Æ[North Ireland]ªº°ÝÃD


¦^´_ 9# Hsieh

[Hsieh]ª©¥D¦A´£¨Ñªº¤½¦¡»P§Ú­pºâ¥X¨Óªºµ²ªG¦³¨Ç¥X¤J
¦Ó¥B¤£©ú¥Õ[Hsieh]ª©¥D¤½¦¡¤¤ªº (SUMPRODUCT(ISNUMBER(FIND($D2,OFFSET($D$1,,,COUNTA($DD),)))*1)-1) ¬°¦ó­n´î1
ÁÂÁÂ!

991002-1.zip (14.87 KB)

°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD