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

[µo°Ý] (¤w¸Ñ¨M)2¦U±ø¥ó+ÅÞ¿è§PÂ_

[µo°Ý] (¤w¸Ñ¨M)2¦U±ø¥ó+ÅÞ¿è§PÂ_

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

¸£³U§Ö¥´µ²¤F
HÄæ§Ú·Q§ì¥X²Å¦Xªºª÷ÃB§ì¥X¨Óªº¸ê®ÆÀ³¸Ó­n·|¸ò³æ»ù¨Ì¼Ë
¦³¨â¦U°ÝÃD
1.h2À³¸Ó¬O¥i¥H§ì¨ì¸ê®Æ¬°¤°»ò§ì¥X¨Ó¬O¿ù»~­È
2.h6³oºØ3000-6000¤§¶¡³æ»ùÀ³¸Ó¬O850 ³oºØ¦³¿ìªk§Ë¦bÂ^¨ú¸ê®Æªº±ø¥ó¸Ì­±¶Ü?ÁÙ¬O¥u¯à¥Î¦h»²§UÄæ?(Ä´¦psheet1¸Ì­±¦b¼W¥[4000¤½¤ç 850 5000¤½¤ç850)

§Æ±æ±Ô­z°ÝÃD¤j®a¥i¥H²z¸Ñ





¦h­«±ø¥ó+ÅÞ¿è§PÂ_.rar (16.4 KB)
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-12-15 15:07 ½s¿è

=OFFSET(Sheet1!$F$1,MATCH(F2,Sheet1!$F$2:$F$8,0),MATCH(G2,Sheet1!$G$1:$N$1,0))
¤£¬Oºë½T¬d§ä¤£¥i¥H¥[ ,0
=OFFSET(Sheet1!$F$1,MATCH(F2,Sheet1!$F$2:$F$8,0),MATCH(G2,Sheet1!$G$1:$N$1))
3000~5000 À³¸Ó¬O880,¤£¬O850§a
À³¬O2000¥H¤U1000,3000¡ã5000,880

TOP

¦^´_ 2# ANGELA


    ª©¥D¬O850¨S¿ù2001-~3000=880 3001~6000=850
    ­è§ÚÀˬd§Úµo²{§Úªº¤½¦¡ÁÙ¦³¤@¦U°ÝÃD¦n¹³¤£¯à³]G1:N1¦]¬°¬O¨C¦U¹ïÀ³ªº¶À¦â°Ï¶¡  
   ³o¦UÁöµMµo²{¤F¥i¬O¤@¼Ë·Q¤£¥Xµª®×
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

=OFFSET(Sheet1!$F$1,MATCH(F2,Sheet1!$F$2:$F$8,0),MATCH(G2,OFFSET(Sheet1!$G$1:$N$1,MATCH(F2,Sheet1!$F$2:$F$8,0)-1,)))

TOP

¦^´_ 4# ANGELA


    ÁÂÁª©¥D
   ¬Q¤Ñ·Q³o¤@¦U¨ç¼Æ·Q¨ì¥´µ²
   «á¨Ó§Ú±N¨Ó·½§ï¦¨¥t¨ÌºØ¤è¦¡
   ª©¥D´£¨Ñªº¤]Åý§Ú¦h¤@ºØ¾Ç²ß

  ·Q­n°Ý¨Ì¤U3000-6000³o¤@ºØ§Ú¬O­n±N3000  4000 5000 6000¤À§O¼Ð¥Ü¶Ü
  ÁÙ¬O¦³¨ä¥¦¤è¦¡¥i¥H¹F¦¨?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 5# freeffly
¬Ý¤UªþÀÉ.À³¥i¤F¸Ñ.

    Book1.zip (3.71 KB)

TOP

¦^´_ 6# ANGELA


    ÁÂÁª©¥D
   ª¾¹Dª©¥Dªº·N«ä¤F
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 6# ANGELA


    OFFSET(A1,1,MATCH(H1,B1:F1))
    OFFSET(A1,1,MATCH(H1,B1:F1,))
   
    ª©¥D½Ð°Ý¤W­±³o¨â¦Uªº®t²§
   ¬°¤°»ò®t¤@¦U","®t¨º»ò¦h?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 8# freeffly


    ¦ü¥G¬OMatch ªº»yªk
    =MATCH(lookup_value, lookup_array, [match_type])
   
   ¨ä¤¤ Match_type
   1 ©Î¬Ù²¤ MATCH ¨ç¼Æ·|§ä¨ìµ¥©ó©Î¶È¦¸©ó lookup_value ªº­È¡Clookup_array ¤Þ¼Æ¤ºªº­È¥²¶·¥H»¼¼W¦¸§Ç±Æ¦C¡A¨Ò¦p¡G...-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE¡C
   0 MATCH ¨ç¼Æ·|§ä²Ä¤@­Ó§¹¥þµ¥©ó lookup_value ªº¤ñ¸û­È¡Clookup_array ¤Þ¼Æ¤ºªº­È¥i¥H¨Ì¥ô·N¦¸§Ç±Æ¦C¡C
   -1 MATCH ¨ç¼Æ·|§ä¨ìµ¥©ó©Î¤j©ó lookup_value ªº³Ì¤p­È¡Clookup_array ¤Þ¼Æ¤ºªº­È¥²¶·¥H»¼´î¦¸§Ç±Æ§Ç¡A¨Ò¦p¡GTRUE, FALSE, Z-A, ...2, 1, 0, -1, -2, ...¡A¥H¦¹Ãþ±À¡C
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 9# softsadwind


    ÁÂÁÂ
    ·Q·Q¦n¹³¬O³o¼Ë
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD