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

[µo°Ý] ¨ç¼Æª¬ºA¦X­p¥[Á`¨D¸Ñ

[µo°Ý] ¨ç¼Æª¬ºA¦X­p¥[Á`¨D¸Ñ

¥»©«³Ì«á¥Ñ cny312323 ©ó 2019-4-28 21:28 ½s¿è

¦U¦ì¥ý¶i

¦p´ú¸ÕÀɤp§Ì¥­±`¨C¤Ñ¤Ñ ´N»Ý¶×¾ã¦p ¤u§@ªí®æ2
¦³®É·|¦³ºØÃþA1~A100 ©Î¬O A1~A70 . A1~A300µ¥
ª¬ºA ¤]·|¦³ ·lÃa,¾P·´, ©Î¬OªÅ¥Õ=©Ò¿×ªº«~¶µok¥i¥H³c½æ

¦ý¬O¦Ó§Ú¨C¦¸©Ò»Ý­nªº ´N¥u¬O ­n¬Y´X­ÓºØÃþ
¦p©T©wªº a1  a5  a11 a22  c17 µ¥µ¥µ¥
¤S­n±q³oÃä©T©wªººØÃþ ¦A§â ·lÃa ¾P·´¦©°£
±oª¾§Ú©Ò²{¦³ªº¥i¥H³c½æªº ­Ü®w¶q ¥H¤Î ¹wÁʶq ¦U¦h¤Ö¸ò¦X­p¥[Á`

¥Ø«e§Ú³£¬O¥Î¼Ï¯Ã¤è¦¡  ¨C¦¸©Ô  ¿z¿ï§Ú·Q­nªº¿ï¾ÜºØÃþ ¸ò ª¬ºA ¦p ¤u§@ªí®æ3

¥u¬O³o¼Ë¨C¤Ñ³£­n¦Û¤v©Ô¼Ï¯Ã§@¿z¿ï. ¤S¦³¦n´X­ÓÀÉ®× ³£­n°µÃþ¦üªº

·Q½Ð°Ý¦³¨S¦³¤°»ò¨ç¼Æ¯à §Ú¥u­n§âªí®æ1 ½Æ»s ¶K¤W¨ì¬Y¤@­Ó¤À·~´N¯à¸õ¥X¦p ªí®æ3  ±oª¾§Ú·Q­nªººØÃþ  ª¬ªp  ­Ü®w¶q  ¸ò ¹wÁʶq¦X­p¥[Á`
¦]¬°§Ú·Q±oª¾ªº ³£¬O ©T©wªº ºØÃþ, ¥i¯à·|¦]¬° ¨C­Ó¤ë ¤~Åܰʤ@¦¸

¥H¤W   Àµ½Ð¦U¦ì¥ý¶i´f¤©½ç±Ð!ÁÂÁÂ!

TEST1.rar (7.33 KB)

C5:D5 ¤U©Ô=VLOOKUP(OFFSET($A$5,INT((ROW(A1)-1)/2)*2,),¤u§@ªí2!$A:$D,5-COLUMN(A1),)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD