¨ú«e3¤p(¤¤¦¡±Æ¦W)ªº¦PÄæ²Ä1¦C¼Æ¦r¡C
- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¨ú«e3¤p(¤¤¦¡±Æ¦W)ªº¦PÄæ²Ä1¦C¼Æ¦r¡C
¥»©«³Ì«á¥Ñ papaya ©ó 2019-4-13 02:02 ½s¿è
´ú¸ÕÀÉ.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¦ì! |
|
|
|
|
|
|
- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¥»©«³Ì«á¥Ñ 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
ÁÂÁÂ! |
|
|
|
|
|
|
- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-14
|
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¦^´_ 3# hcm19522
hcm19522¤j¤j:!±z¦n!
µª®×´ú¸ÕOK¤F!ÁÂÁ±z!
=ISERR(H7) =>¤£¦n·N«ä¡A°£¿ù¤½¦¡n«ç»ò¼g?
¸Û½Ð½ç±Ð!¦A¦¸ÁÂÁ±z! |
|
|
|
|
|
|
- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-14
|
¦^´_ 4# papaya
°é¿ïH7:J28-->ÂI³]©w®æ¦¡¤Æ±ø¥ó (±`¥Î¤U ¤W¤è¤¤¶¡)-->¤U¤½¦¡-->¿ï¦â |
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¦^´_ 5# hcm19522
hcm19522¤j¤j:±z¦n!
ÁÂÁ±zªº@¤ßÀ°¦£~·P®¦^^
§Ú¦Û¤v¦Û§@Áo©ú¡A¥X¤F¤@¨Çª¬ªp^*^
µ¥¾ã²z¦nÀɮסA¦AÄ~Äò¦V±z½Ð±Ð!
ÁÂÁ±z! |
|
|
|
|
|
|
- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¦^´_ 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 |
|
|
|
|
|
|
- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-14
|
¦^´_ 7# papaya
AZ7=SMALL(OFFSET($B7,,MAX(INT((COLUMN(A1)-1)/3)*5),,5),MOD(COLUMN(A1)-1,3)+1) |
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|
- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
|
|
|
|
|
|
- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-14
|
¦^´_ 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©Ô |
|
google"EXCEL°g" blog ©Îgoogleºô§}:https://hcm19522.blogspot.com/
|
|
|
|
|