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

Validation ¿z¿ïªº°ÝÃD

Validation ¿z¿ïªº°ÝÃD

±ø¥ó¦¡¿z¿ïªº°ÝÃD¡A¦³¤H¥i¥HÀ°¦£¶Ü¡H George problem.rar (3.18 KB)
­É¿ú¤£ÁÙ¡A¤~¬O¤ý¹D

1/COUNTIF(z,z)  , ¥Î 1 °£ ¡A¤£¬OÅܦ¨¤p¼Æ¤F¶Ü¡H
­É¿ú¤£ÁÙ¡A¤~¬O¤ý¹D

TOP

­n¥Îvbaªº¸Ü¡A²Ä¤@­Ó¤U©Ô²M³æ³q±`¦bopen®É¼g¤J¡A²Ä¤G­Ó¤U©Ô²M³æ¦b§ïÅܲĤ@­Ó¤U©ÔÀx¦s®æ®É§@§ïÅÜ
Á׶}¤£¥²­nªº©µ¿ð¡C¤£¥²«Ø¥ß¥ô¦ó¦WºÙªº¡I George problem.rar (12.43 KB)

TOP

¦^´_ 10# apolloooo

¸ê®ÆÅçÃÒªº²M³æ
¨Ó·½«¬ºA¦³¨âºØ
1.³sÄòÀx¦s®æ(³æÄæ©Î³æ¦C)(¦p¤U¹Ï)

­Y­n¸óªí«h»Ý¨Ï¥Î©w¸q¦WºÙ(¦p¤U¹Ï)

2.¥H³rÂI¤À¹j¶µ¥Øªº¦r¦ê(¦p¤U¹Ï)

­Y¥HVBA«h¥i¥H¤W­zªº«¬ºA¼g¤J¡A´N¤£¶·¦A­É§U©w¸q¦WºÙ¤F
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

­Ë¬O»¡¡A¬°¤°»ò¤£¦æª½±µ¥ÎVBA§âÀx¦s®æª½±µValidation ´N¦n¤F¡A¤Ï¦Ó­n³z¹L©w¸q¦WºÙ¤~¦æ¡C
­É¿ú¤£ÁÙ¡A¤~¬O¤ý¹D

TOP

³Ì«á§Ú»{¿é¤F¡A¥ÎVBA¸Ñ¨M¥¦¡A´N¤£¥Î¦V¦P¨Æ¸ÑÄÀ¨º»ò¦h¤F George problem.rar (11.41 KB)
­É¿ú¤£ÁÙ¡A¤~¬O¤ý¹D

TOP

§Ú¦b2003¤¤¡Alookup¤@¦V»Psumproduct¤@¼Ë¤£¯à«ü©w¾ãÄæ

TOP

¦^´_ 3# oobird

§Ú­ì¬O¦b2010ª©½s¿è
­ì¨Óx¦WºÙ¨Ï¥Î
=LOOKUP(1,1/(Sheet1!$D:$D<>""),ROW(Sheet1!$D:$D))-6
¬O¥i¥H¦¨¥\¡A¸gª©¥D´£¿ô¡A¤µ¤Ñ¥H2003¶}±Ò½T¹ê³y¦¨¿ù»~¡A¤½¦¡§ï¦¨¦p¤U
=LOOKUP(1,1/(Sheet1!$D$6:$D$65536<>""),ROW(Sheet1!$6:$65536))-6
³o¼Ë¯à°÷³q¹L2003ª©¥»
¬°¦ó·|¦³³o¼Ë±¡§Î?ÁٽЦU¦ì´£¥X¬Ýªk
·Ó²zLOOKUP¨Ã¤£·|¦]¬°¾ãÄæ¦Ó¤£»{¬°¬O°}¦C
²ö«D2010ª©¦]¬°¦C¼Æ¼W¦h¡A©Ò¥HÀÉ®×°O¾Ð¨ä½d³ò¶W¥X2003ª©©Ò­P?
¦ý¬O¡A§Ú¦b2003ª©­«·s¥H¾ãÄæ©w¸q¤´µM¤£¯à¦¨¥\
½Ð¦U¦ì¥ý¶i½ç±Ð
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

³o¥yªº¥Î·N¬O·í¤½¦¡©Ò¦b¦C¤j©ó±ý¨ú±oªº¤£­«½Æ­È®É¡A¥ÎªÅ¥ÕÅã¥Ü¡A¤~¤£¥X²{¿ù»~²Å¸¹¡C

TOP

¦^´_ 4# apolloooo


    ROW(A8)>SUM(1/COUNTIF(z,z)) <-- ·Q°Ý³o¥y¬O«ç»ò¦^¨Æ¡C
z¬O¤@­Ó°Ï°ì½d³ò
SUM(1/COUNTIF(z,z)) ¬O³o­Ó½d³òªº¤£­«ÂЭӼÆ
ROW(A8)=8

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD