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

[µo°Ý] ¦³Ãö¨Ï¥Î¤½¦¡®»¨ú¸ê®Æ

[µo°Ý] ¦³Ãö¨Ï¥Î¤½¦¡®»¨ú¸ê®Æ

¥»©«³Ì«á¥Ñ icestormer ©ó 2014-1-12 11:20 ½s¿è


¦p¤W¹Ï §Q¥Î¨º¤½¦¡ ¥ý±qA3ªº¦WºÙ §ä¨ìM6ªº ¦A¦ì²¾¨ì R6 ¨ú±o¥¦¼Æ¾Ú 100,000 ³o³¡¥÷§¹¥þ¬O¥¿±`¨S¦³°ÝÃD


¦ý§Ú·Q°µªº¬O ¯à¤£¯à¦³¤@­Ó¤½¦¡¸ò=INDIRECT(ADDRESS(MATCH(OFFSET(A3,,),$M:$M,0)+0,18))«Ü¹³
¦ý­n®»¨úªº¸ê®Æ¬O¦b²Ä¤G­¶¦p¤U¹Ï

¥D­n·Q°Ýªº¬OINDIRECT(ADDRESS(MATCH(OFFSET(A3,,),$M:$M,0)+0,18) ¬õ¦r°Ï¯àÅܦ¨¥þ¤u§@ªí¥þ½d³ò(1:65536)?
¥Ñ©ó¸ê®Æ·|¦³2 3¤dµ§ ¦pªG¯àÅý³æ¦æÅÜ¥þ½d³ò§ä¨ì¯S©w¦WºÙ ·|¬Ù¤O¦h

PS¤£¦n·N«ä §Ú¨ä¹ê¤]¤£¤Óª¾¹D§Úªí¹Fªº¹ï¤£¹ï..·|ªþ¤WÀÉ®× ·PÁ¦U¦ìªºÀ°¦£




Book1.rar (2.63 KB)

¯Á¤Þªº¸ê®Æ·|¦³­«½Æªº±¡ªp¶Ü?
¦pªG¤£·|­«½Æªº¸Ü
A10=SUMIF(B:IQ,A3,G1)

ª`·N¤½¦¡­n©ñ¦bAÄæ

­n±N¥þ¤u§@ªí¥þ½d³ò(1:65536)·í¦¨¯Á¤Þ¸ê®Æ½d³òªº¸Ü·|³y¦¨´`Àô°Ñ·Ó(¦]¬°¤½¦¡¦bAÄæ)
©Ò¥H±N¯Á¤Þ½d³ò³]¬° B:IQ Äæ,À³¸Ó°÷¤j¤F
¤@©w­n±N¥þ¤u§@ªí¥þ½d³ò(1:65536)·í¦¨¯Á¤Þ¸ê®Æ½d³òªº¸Ü,¥i¥H±N¤½¦¡©ñ¦b¨ä¥L¤u§@ªí
¤½¦¡§ï¬°  =SUMIF(2!A:IQ,A3,2!F1)
My Blog
http://blog.xuite.net/a8350070

TOP

¦^´_ 2# a8350070


    INDIRECT(ADDRESS(MATCH(BA5&" - Market Browser",t!A:A,0)+9,3,,,"t")) §Ú¦Û¤v§Ë¥X³o­Ó¥i¥H¥Î ¨º­Ó T=§O¤u§@ªí

¥u¬OÁÙ¬O¥u¯à °w¹ï¦P¤@¦æ(A:A)¨Ó§ä..

·PÁ§A¦^À³

TOP

¦^´_ 3# icestormer

=INDIRECT("'2'!R8C"&MATCH($A$3,'2'!8:8,0)+5,0)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


  ·PÁ §Ú¥h¸Õ¬Ý¬Ý

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD