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

(¤w¸Ñ¨M)½Ð°Ý³oºØ·j´M¤è¦¡¦³¨ç¼Æ¥i¥H°µ¨ì¶Ü

(¤w¸Ñ¨M)½Ð°Ý³oºØ·j´M¤è¦¡¦³¨ç¼Æ¥i¥H°µ¨ì¶Ü

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:11 ½s¿è

§Ú­n·j´M"¶Ç²¼½s¸¹"¤@¼Ë¥B"¶U¤èª÷ÃB"¤£¬°0ªº¸ê®Æ
¦pªþ¥ó±¡ªp²Å¦Xªº¸ê®Æ¬OD33
¤£ª¾¹D³o¼Ë»¡©ú¦U¦ì¬ÝªºÀ´¶Ü?







Book1.rar (2.22 KB)
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

¦^´_ 1# freeffly

"¶Ç²¼½s¸¹"»P¤°»ò¤@¼Ë

"¶Ç²¼½s¸¹"¤£³£¬O¤@¼Ëªº
¨º¬O¤£¬O¥u­n§PÂ_"¶U¤èª÷ÃB"¤£¬°0ªº¸ê®Æ

TOP

¦^´_ 2# register313
§Ú­n§ä¦P¤@¦U¶Ç²¼½s¸¹¤¤¶U¤èª÷ÃB¦³¼Æ¦rªº¬ì¥Ø
§Ú³oÃä¥u©ñ¦P¤@±i¶Ç²¼
§Ú­n³B²zªº¸ê®Æ¦³¦n´X±i¶Ç²¼
¤£ª¾¹D³o¼Ë»¡©úÀ´¶Ü?


·sªþ¥ó¬O¤ñ¸û¦h¸ê®Æ¡A§Ú·Q­n¨ú±oªº¬O-«á­±ªº¸ê®Æ
§Æ±æ¤£·|¶V»¡¶V½ÆÂø
    Book2.rar (4.81 KB)
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦pªG¹³½d¨Ò¥u¦³°ß¤@­È¥i¥Î=LOOKUP(9.9E+307,F:F)
¦³¦h­È
=IF(ROW(1:1)>COUNTIF(F:F,">0"),"",INDEX(F:F,SMALL(IF(($F$5:$F$33<>0)*($B$5:$B$33=$B$5),ROW($5:$33)),ROW(1:1))))
  °}¦C¤½¦¡

TOP

¦^´_ 4# ANGELA


    =INDEX(D:D,SMALL(IF(($F$5:$F$33<>0)*($B$5:$B$33=$B$5),ROW($5:$33)),ROW(1:1)))
     ªO¥D§ÚÀ³¸Ó¬O­n³o¤@¬q´N¥i¥H
   ¦ý¬Oµ²ªG¥u¥X²{¤@¦U¸ò§Ú­nªºÁÙ¦³¤@ÂI®t¶Z
   ½Ð°Ý«ç»ò§ï?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 3# freeffly

Book2.zip (27.39 KB)

TOP

¦^´_ 6# register313


    ³oºØ±¡§Î¬O¤£¬O¥u¯à¹³¤j¤j³o¼Ë¤À¬q³B²z
   µM«á¦A¥ÎVLOOKUP ©Î¬O OFFSET¥h³B²z§A§ì¥X¨Óªº¨º¤@¶ô¸ê®Æ?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 7# freeffly


    ¤£¥Î¤À¬q³B²z
   §Ú¥u¬O§â¥þ³¡ªºÄæ¦ì³£§ì¥X¨Ó
  §A­n¬ì¥Ø¦WºÙ ¥i¥H¥u³]©w¸ÓÄ檺¤½¦¡§Y¥i ¦UÄ椣¬Û¦C¼vÅT

TOP

¦^´_ 8# register313
§Ú¬O·Qª½±µ¹³g5:g32¨º¼ËÅã¥Üµ²ªG
¥Ø«e§Ú·Qªº¨ìªº¤è¦¡´N¬O³o¼Ë³B²z

   



aaa.rar (18.26 KB)
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-1-4 07:56 ½s¿è

¦^´_ 9# freeffly

1.¨Ï¥Î IF¨ç¼Æ
  G5=IF(F5=0,G6,D5)
2.³]©w®æ¦¡¤Æ±ø¥ó

aaa.zip (32.83 KB)

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD