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

¨ú«e3¤p(¤¤¦¡±Æ¦W)ªº¦PÄæ²Ä1¦C¼Æ¦r¡C

¨ú«e3¤p(¤¤¦¡±Æ¦W)ªº¦PÄæ²Ä1¦C¼Æ¦r¡C

¥»©«³Ì«á¥Ñ papaya ©ó 2019-4-13 02:02 ½s¿è

¥¼©R¦W.png
2019-4-13 01:55


´ú¸ÕÀÉ.rar (1.76 KB)

H7=B7:F7ªº³Ì¤p¼Æ¦rªº²Ä1¦C¦PÄæ¼Æ¦r(³Ì¦h5­Ó¡A§Y¤U©Ô¨ìH11)¡A
I7=B7:F7ªº²Ä¤G¤p¼Æ¦rªº²Ä1¦C¦PÄæ¼Æ¦r(³Ì¦h4­Ó¡A§Y¤U©Ô¨ìH10)¡A
J7=B7:F7ªº²Ä¤T¤p¼Æ¦rªº²Ä1¦C¦PÄæ¼Æ¦r(³Ì¦h3­Ó¡A§Y¤U©Ô¨ìH9)¡A

H14,H21,H28 =>¦P²zÃþ±À¡C
I14,I21,I28 =>¦P²zÃþ±À¡C
J14,J21,J28 =>¦P²zÃþ±À¡C

½Ð°Ý¡JH7¡JJ7ªº¨ç¼Æ¤½¦¡¡H
¸Û½Ð¦U¦ì¤j¤jÀ°¦£©M½ç±Ð!
ÁÂÁ¦U¦ì!

¥»©«³Ì«á¥Ñ papaya ©ó 2019-4-13 05:28 ½s¿è

­×¥¿µ§»~:
(³Ì¦h4­Ó¡A§Y¤U©Ô¨ìH10)=>(³Ì¦h4­Ó¡A§Y¤U©Ô¨ìI10)
(³Ì¦h3­Ó¡A§Y¤U©Ô¨ìH9)=>(³Ì¦h3­Ó¡A§Y¤U©Ô¨ìJ9)
½Ð°Ý¡JH7¡JJ7ªº¨ç¼Æ¤½¦¡¡H =>½Ð°Ý¡JH7¡AI7¡AJ7ªº¨ç¼Æ¤½¦¡¡H
ÁÂÁÂ!

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 3# hcm19522
hcm19522¤j¤j:!±z¦n!
µª®×´ú¸ÕOK¤F!ÁÂÁ±z!

=ISERR(H7)  =>¤£¦n·N«ä¡A°£¿ù¤½¦¡­n«ç»ò¼g?
¸Û½Ð½ç±Ð!¦A¦¸ÁÂÁ±z!

TOP

¦^´_ 4# papaya
°é¿ïH7:J28-->ÂI³]©w®æ¦¡¤Æ±ø¥ó (±`¥Î¤U ¤W¤è¤¤¶¡)-->¤U¤½¦¡-->¿ï¦â
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 5# hcm19522
hcm19522¤j¤j:±z¦n!
ÁÂÁ±zªº­@¤ßÀ°¦£~·P®¦^^

§Ú¦Û¤v¦Û§@Áo©ú¡A¥X¤F¤@¨Çª¬ªp^*^
µ¥¾ã²z¦nÀɮסA¦AÄ~Äò¦V±z½Ð±Ð!
ÁÂÁ±z!

TOP

¦^´_ 5# hcm19522
hcm19522¤j¤j:
¤£¦n·N«ä¡A¦]¬°·QÅý¸ÑÃDªÌ®e©ö¾\Äý¡A©Ò¥H±Nªí®æ¤º®e¤º®e²¤Æ¡A¦ý·Q¨ì²K¤J§¹¾ã¤º®e«o¼vÅT¨ì¤½¦¡ªº¸Ñµª¡F
¦]¦Û¤vªº¦Û§@Áo©ú¡Aµ¹±z²K³Â·Ð¡A©|½Ð¨£½Ì^^"

¨C°Ï¬qªº«e¤T¤p.rar (768.88 KB)

»Ý¨D¡J
±NB¡JAX¦@49Äæ¤À¦¨5Äæ+5Äæ+5Äæ+5Äæ+5Äæ+5Äæ+5Äæ+5Äæ+5Äæ+4Äæ¦@10°Ï¬q
²Î­p¦U°Ï¬q¦b²Ä7,14,21,28,35,42,49,56,63,69¦Cªº³Ì¤p©M²Ä¤G¤p©M²Ä¤T¤p(¤¤¦¡±Æ¦W)ªº¦PÄæ²Ä¤@¦Cªº¼Æ¦r¡C
½Ð°Ý¡JAZ7¡JCC7ªº¨ç¼Æ¤½¦¡¡H
¸Ô¦p¡J°Ï¬q´ú¸ÕÀÉ¡C
ÁÂÁ±z¡I

TOP

¦^´_ 7# papaya


    AZ7=SMALL(OFFSET($B7,,MAX(INT((COLUMN(A1)-1)/3)*5),,5),MOD(COLUMN(A1)-1,3)+1)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2019-4-14 11:12 ½s¿è

¦^´_ 8# hcm19522
¥¿½Tµª®×
¥¿½Tµª®×.png
2019-4-14 11:00

           
¥Ø«e¤½¦¡ªºµª®×
¥Ø«e¤½¦¡ªºµª®×.png
2019-4-14 10:58

¸ÑÃD¤½¦¡.rar (726.35 KB)
hcm19522¤j¤j:±z¦n!
¤£¦n·N«ä¡A¶Q¸ÑÃD¤½¦¡ªºµª®×¯Ê¤Ö"¤¤¦¡±Æ¦W"©M"Åã¥Ü¦PÄæ²Ä¤@¦C¼Æ¦r"ªº»Ý¨D¡F¥t¥~¤U©Ô«á¦³«Dµª®×ªº¼Æ¦r¡C
·Ð½Ð½ç¥¿!
ÁÂÁ±z!

TOP

¦^´_ 9# papaya


    (¨C°Ï»²§U)AZ6:CC6{=SMALL(IF(IFERROR(MATCH(OFFSET($B7,,MAX(INT((COLUMN(A1)-1)/3)*5),,5),OFFSET($B7,,MAX(INT((COLUMN(A1)-1)/3)*5),,5),),99)={1,2,3,4,5},OFFSET($B7,,MAX(INT((COLUMN(A1)-1)/3)*5),,5)),MOD(COLUMN(A1)-1,3)+1)

AZ7:CC11{=IFERROR(SMALL(IF(OFFSET($B$7,,MAX(INT((COLUMN(A1)-1)/3)*5),,5)=N(OFFSET(AZ$1,ROW()-MOD(ROW(A1),7)-1,)),OFFSET($B$1,,MAX(INT((COLUMN(A1)-1)/3)*5),,5)),MOD(ROW(A1)-1,7)+1),"")

AZ6:CC6½Æ»s¨ì¨C°Ï   ;AZ7½Æ»s¨ì¨C°Ï ­×§ï¤@³B$B$7-->$B$14 ¥k©Ô ¤U©Ô
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD