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

¤½¦¡¸ß°Ý

¤½¦¡¸ß°Ý

¤£ª¾¸Ó¤U¤°»ò¤½¦¡?
   
    ¤½¦¡¸ß°Ý.rar (14.06 KB)

¦^´_ 1# Qin

I2 =IF(ROW(A1)>COUNTIF(¸ê®Æ®w!C:C,A$2),"",MATCH(A$2,OFFSET(¸ê®Æ®w!C$1,N(I1),,999),)+N(I1))
¤U©Ô

B2 =IF($I2="","",INDEX(¸ê®Æ®w!$A:$G,$I2,MATCH(B$1,¸ê®Æ®w!$1:$1,)))
¥k©Ô¦ÜG2¡A¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

   ´ú¸Õ¤F, Ok
   ¥i¥H¥Î"½s¸¹"·j´M,
   «Ø¥ß¦h¤@­¶, ¤S¥i¥H¥Î"«~¦W"·j´M
   ¹ê¦b¤Ó¦n¥Î¤F.
   µL¨¥·PÁÂ!

TOP

¦^´_ 2# ML089

     ML089ª©¤j,
     ·í¸ê®Æ®wªº¸ê®Æ¦³99999µ§®É, ¹q¸£´N¶]±o«ÜºC«ÜºC, ¦³¤°»ò¤èªk¥i¥H¸Ñ¨M?

    I2 =IF(ROW(A1)>COUNTIF(¸ê®Æ®w!C:C,A$2),"",MATCH(A$2,OFFSET(¸ê®Æ®w!C$1,N(I1),,99999),)+N(I1))

TOP

¦^´_ 4# Qin

COUNTIF ¹Bºâ¤ñ¸ûºC¡A­Y¸ê®Æ¤£¦h¼vÅT¤£¤j¡ACOUNTIF ¥u­nºâ¤@¦¸¥i¥H¸`¬Ù¤@ÂI®É¶¡

I3 =IF(ROW(A1)>COUNTIF(¸ê®Æ®w!C:C,A$3),"",MATCH(A$3,OFFSET(¸ê®Æ®w!C$1,N(I2),,9999),)+N(I2))

§ï¬°

I2 =COUNTIF(¸ê®Æ®w!C:C,A$3)

I3 =IF(ROW(A1)>I$2,"",MATCH(A$3,OFFSET(¸ê®Æ®w!C$1,N(I2),,9999),)+N(I2))
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089

  ML089ª©¤j
  ¤½¦¡¿é¤J¦Z, µª®×Åã¥Ü¤£§¹¾ã.
   ¤½¦¡¸ß°Ý_2°Ý.rar (39.49 KB)

TOP

¦^´_ 6# Qin

J1¼Æ¦r¤zÂZ

­×§ï¬°
J1 ="Á`¼Æ:00"&COUNTIF(¸ê®Æ®w!C:C,A$2)

J2 =IF(ROW(A1)>--RIGHT(J$1,3),"",MATCH(A$2,OFFSET(¸ê®Æ®w!C$1,N(J1),,9999),)+N(J1))   
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089


    ­º¥ý,·PÁÂML089 ª©¤jªº¨ó§U,¥H¤W°ÝÃD¸Ñ¨M¤F

     ¦ý¦³¤£¸Ñªº¦a¤è,ÁÙ·Q½Ð±Ðª©¤j

     1) "Á`¼Æ:00" ¬O¤°»ò·N«ä?

     2) ¦p·Q·j´M¥X¨Óªº"µª®×"¦pªþÀɦ³"ÃC¦â"¯ë²M´·¬üÆ[, ½Ð°Ý¤S­n¦p¦ó°µ©O?
      
         ÁÂÁÂ!

    ¤½¦¡¸ß°Ý_2°Ý.rar (39.91 KB)

TOP

¦^´_ 8# Qin

J1 ="Á`¼Æ:00"&COUNTIF(¸ê®Æ®w!C:C,A$2)

J2 =IF(ROW(A1)>--RIGHT(J$1,3),"",MATCH(A$2,OFFSET(¸ê®Æ®w!C$1,N(J1),,9999),)+N(J1))   
¤U©Ô

°²¦p ¸ê®Æ¦³ 99 µ§
=Á`¼Æ:00 & COUNTIF(¸ê®Æ®w!C:C,A$2)
°õ¦æ¦p¤U
"Á`¼Æ:0099"     

J2 =IF(ROW(A1)>--RIGHT(J$1,3),"",MATCH(A$2,OFFSET(¸ê®Æ®w!C$1,N(J1),,9999),)+N(J1))   
¤¤ªº --RIGHT(J$1,3)
°õ¦æ¦p¤U
99

·í ¤U©Ô 100¦C ®É ROW(A1) =100 ´N·| > 99¡A¥uÅã¥Ü ""
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089


    ÁÂÁÂ!±zªº­@¤ß¸ÑÄÀ...

    ÁÙ·Q¸ß¶¡, ·j´M¥X¨Óªº"µª®×"¦pÄÝ Excel row °¸¼ÆÅã¥Ü¦Ç¦â,©_¼Æ«hÅã¥Ü¾í¦â

    §Ú³]¤F®æ¦¡¤Æ±ø¥ó¦p¤U:

    °¸¼Æ=Mod(Row(),2)=0

    ©_¼Æ=mod(Row(),2)=1

    ¦ý¬O,§Ú·Q­nªº¬O·í·j´Mµ²ªG¥X¨Ó®É¬O10¦æ¸ê®Æ´N¦³«ü©wªºÃC¦â, ¦Ó¥Ñ²Ä11¦æ¥H¤U¬O¨S¦³ÃC¦âªº.

    ½Ð°Ý­n¦p¦ó¤U¤½¦¡?

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD