                     qTTTTTTTTTTTTTTTTTTr                            
                     U     ==  Excelٱ7.2  ==     U                           
     qTTTTTTT     61ߺ25     TTTTTTTTr
     U              U     ȫλĹЧ       U                U
     U              tTTTTTTTTTTTTTTTTTTs                U
     U                                                                      U
     U      qr      U
     tTTT  ߣ޸վ QQ670218239  Maill:andy_qc@163.com   TTTs
             ts

qTTTTTTTTTTTTTTTTT   ˵һ   TTTTTTTTTTTTTTTTTr                            
U  ݹʼ㳮ƱвС۷ֹ۷֡ϲ    U   
U  ıֵѡ򹤾ߡ䡿СдתддתСд    U   
U  ɾָϸҳСơɾҳСơͼƬĿ¼    U   
U  ͼƬͼƬעɾͼƬͼƬɸԻע  U   
U  GIFFlashȡѡظֵظֵʾظֵ        U   
U  ɾհ׵ԪСɸѡΨһֵֹ¼ظֵͬ벻ͬļĿ¼  U   
U  Ŀ¼½ƹӽܡƽ⹤/롿 ļU   
U  ݼܡĺϲСɻԭĺϲϲֵͬȡϲԭݡU   
U  ϲݲơ߼λ䡿ѡɫѡ񡿡ıַ㡿  U   
U  ʽǧټĸСũ˫ѯһطʹ      U
U  б߱ͷӡǰҳ˫ӡɵ׶˱⡿ת塿ת塿    U   
U  ϵͳͼ꡿ȡID޸ExcelҳƽVBA롿               U                                            
U                                                                                          U                           
tTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTs

qTTTTTTTTTTTTTTTT    Զ庯һ    TTTTTTTTTTTTTTTTr                            
U  sumifcolAVERhesumNOWWSFZעϲȡΨһֵ            U
U  ֵɫ͡ɫָ֡ȡ              U
U  ͬʽ㡿ʽȡд򡿡滻ظ            U
U                                                                                          U                           
tTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTs



<TTTTTTTTTTTTTTTTTT    ˵ܽܣ86ܣ    TTTTTTTTTTTTTTTTTTTT>

ݹʼ㳮ƱԱĹʼҪ100Ԫ50Ԫ......1ԪĳƱ㡣ֽʵĲ߱ر
вСԹвУ߸вУԶ
۷ָֹÿֳɵĹ¹Ƶԭ
۷֡ǰݰֳɶеΪ
ϲָļййݺϲֺϲʽÿеĹϵǰǣӦͬͬݺϲͬһСͬĴ
ıֵѡ˲תıѡı˲תֵ
ѡ򹤾ߡɸѡ򣨷д򹴵ĹߣѡȡѡҿԶ帴ǷԴӡ뵥Ԫӵȵ
䡿WordзܣʹExcelҲͬ๦ܡ̫˷Ѵӡֽʱñ߷ֳɶٴӡ
СдתдСдתɴд
дתСддתСд
˲佫ϸɹӡüԼ幤ͷ
ɾָϸɾǰһɵĹͷָϸ
ҳСơÿҳݽСƺۼƣԶҳСƺۼÿҳĩ
ɾҳСơɾСۼƣָϸ
ͼƬĿ¼ָļͼƬGIFPNGJPGĿ¼
ͼƬڽͼƬĿ˲䵼ͼƬԪ񣬿趨ͼƬĴСʽ
ͼƬעؽͼƬ뵽עУ趨ͼƬʾС
ɾͼƬɾǰͼƬ
ͼƬǰǶͼƬӲгΪJPGͼƬ
ɸԻעExcelֻзע߿ֻıע۴
GIFGIF빤вţԶ嶯ĴСλ
FlashFlash빤вţԶ嶯ĴСλãFlashǶ빤
ȡѡظֵѡݣڵǰУظֵ
ظֵѡظֵɾһγֵݣ
ʾظֵظ֣һκԣúɫ߱ʾ
ɾհ׵ԪС1ɾհУпհף2ɾհ׵Ԫ
ɸѡΨһֵѡһΪΨһֵɸѡ1ɾظֵУ2ظֵ
ͬ벻ͬȡݵĹͬͲͬҲԶݵĲͬͬбʾ
ļĿ¼ָļеļĿ¼ӣԴ򿪶Ӧļ
Ŀ¼ԵǰйĿ¼ţӣԴ򿪹
½/ƹ½߸ƹ˲佨/1255½ʱȫԶ
ӽܡԹм롢루ֻԼõ룩
ƽ⹤/롿ƽ⹤͹롣ڲ֪ǰһ
ݼܡԹѡݽмܣת룬ſԲ鿴ڶִʱԻָ
ļָļļ޶ļͻ߶ļԭļǰߺƣҲ滻ԭ
ֹ¼ظֵָн¼ƣظʱʾظԼظ
ĺϲСExcelĺϲֻܱϽݣߺϲݣҿԶ
ɻԭĺϲСϲ˳ݺȡϲԻԭݣǿExcelԴĺϲ
ϲֵͬһͬڵкϲ
ȡϲԭϲݡһкϲĵԪȡϲһָϲǰ
ϲݲơԽһֱӸƵһԪ
߼λ䡿๦ѡ񣨲ңߡѡĳֵСĳֵĳΧֵ֮ıλʱ֧ͨ
ѡɫѡнɫʾͻǰУݲ鿴ضɫɵɫǳͬ๤вƻɫʽճͳ֮ŵ
ѡ񡿣ѡǰδѡ
ıַ㡿ضԵԪıַ룬Լȡıʽ
ʽǰйʽ˿ʽֻܿʽ
ǧԪǧڡĬʾµɵ¡
ټĸСкڵԪнаټĸ䣬¼ٶ
ũ˫ѯɶ๦Բѯнڡպũ
һطʹԿհ˲ѡöǵǰйָʱҲֻҪ˲ɣ1룩
б߱ͷExcelûWordб߱ͷߣ߿ֲ˲㡣ߡ˫߿ѡ
ӡǰҳӡǰҳ
˫ӡӡ˫Сר
ӡ׶˱⡿Ϊ׶˱дӡֲExcelֻж˱֮
ת塿תɷ
ת塿תɼ
ϵͳͼ꡿VBAԱõĹߡԲѯExcelڲͼID
ȡIDVBAԱõĹߡԲѯExcelڲID
޸ExcelExcelĳЩ޷ʹʱԵ޹ʶܶ˵ʱ߿˲ָExcelĬ״̬
ƽVBA롿VBAдĳƽ⣬˲
ҳϽĿ¼ʹãκι˲䷵صһ

<TTTTTTTTTTTTTTTTTT    ܽ    TTTTTTTTTTTTTTTTTTTT>
ƣsumifcol
    ɫ͡òеΪѡһΪ򣬵ڶΪɫΪ򣬼һɫڶͬ,򽫶ӦĵĵԪ͡ʡԵԵһ͡
ƣAVER
    ֺȥֵСֵ֮ƽ255Excel2003130
ƣhesum
    Һϲ͡1/2͵ֻ1.5ݺͣΪ1212㣬Ϊ1/21.5㡣
ƣNOWW
	ıĵǰʱ䡣Ҫʱʾڵʱ䣬ʱıı䡣
ƣSFZ
    ֤ϢһΪãڶ롰DQȡص롰XB򷵻Ա롰SR򷵻աԵڶĬʾ
ƣд
    תΪҽдҪһԪá
ƣע
    ȡעеֻ֡һԪá
ƣϲ
    ַϲһΪָڶΪ򡣿""ʾʹ÷ָʼΪ򣬿1254Excel2003129Ҳֱı
ƣȡ
    ıһΪԪ񣻵ڶΪѡΪ0ʡʱʾȡ֣Ϊ1ʱʾų֣Ϊ2ʱʾȡΪ3ȡҼ
ƣΨһֵ
    زظֵԶ1253Excel2003128ȡΨһֵǰΪѡΪѡһΪROWʱкȡֵ,ΪCOLUMNʱкУִСдʼΪ
ƣֵ
    ֵѡж,к֮ʽֵ.,һΪһΪš
ƣɫ
    ɫֵ͡һΪֵڶΪ
ƣɫ
    ɫ֮ͬݸһΪֵڶΪ
ƣ
    ȡһ빤ַع
ƣ
    롰д෴дַתΪ֡
ƣָȡ
    ָȡһΪԪ񣬵ڶʾȡNʾָ
ƣ
    ĿǰΪ򣬵Ϊš
ƣͬ
    صһжڶûеĿǰ򣬵Ϊš
ƣʽ
    ʽȡԪеĹʽֻҪһԪá
ƣ
    㺯㵥Ԫеıʽ絥ԪΪ456+2458ֻҪһԪá
ƣʽ
    㵥ԪйʽĳȣһԪá
ƣ
    йʽβϣ˲еڶʱȻڵһΪɼ򣬵ڶΪĳɼá
ƣ
    ִ򡣶ݽִַڵһλȻνݡһΪãڶΪΣʹROW(a1)
ƣ滻
    滻NγֵַĺһΪãڶΪ滻ַΪַĲָ滻ڼγֵַΧ1256֮䡣
ƣظ
    жָǷظԪĺֻһΪãΪTrueʱʾظظ
                       qTTTTTTTTTTTTTTTTTTr
                       U                                    U
       qTTTTTTT        ߰װ              TTTTTTTTr
       U              U                                    U                U
       U              tTTTTTTTTTTTTTTTTTTs                U
       U            װ˫װ.bat1س                       U
       U            ɾ˫װ.bat2س                       U
       U                                                                      U
       tTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTs

qTTTTTTTTTTTTTTTTT װɹԭ TTTTTTTTTTTTTTTTTr                            
U  ޷װע5㣺                                                         U   
U   һȽѹٰװֱRARд޷ʹõ                                        U  
U   OFFICEɫ桢棬ǲ֧COMغ                        U  
U   رExcel״̬°װɾ                                                  U  
U   ģVISTAWIN 7ԹԱûװҴӿйصûʻƹ         U  
U   壺װEXCELߣȹصпɾߵĲ˵                    U              
U                                                                                          U                           
tTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTs

                  qTTTTTTTTTTTTTTTTTTTTTTr
                  U     ʹκʻµĽ           U
                  U     ϵ QQ:670218239              U 
                  U̳http://andysky.5d6d.com/bbs.php   U 
                  tTTTTTTTTTTTTTTTTTTTTTTs  
