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

[µo°Ý] «ü©wÀx¦s®æ¼Ð¥ÜÃC¦â

[µo°Ý] «ü©wÀx¦s®æ¼Ð¥ÜÃC¦â

¥¼©R¦W.png
2019-12-4 09:14

´ú¸ÕÀÉ¡J «ü©wÀx¦s®æ¼Ð¥ÜÃC¦â.rar (2.94 KB)
¦U¦ì¤j¤j¡J
±N·j´M½d³ò=B4:B30(EX¡JSheet1) ªº³]©w®æ¦¡¤Æ±ø¥ó¤½¦¡
§ï¬°
·j´M½d³ò=B4,B11,B18,B25(EX¡JSheet2) ªº³]©w®æ¦¡¤Æ±ø¥ó¤½¦¡¡C

½Ð°Ý¡JSheet2! B4,B11,B18,B25ªº3­Ó³]©w®æ¦¡¤Æ±ø¥ó¤½¦¡­n«ç»ò¼g¡H
ÁÂÁ¡I

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

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-12-4 15:58 ½s¿è

¦^´_ 2# hcm19522
±ø¥ó¦¸§Ç½Õ¾ã¬°ºñ¶ÀÂÅ¡C
¤½¦¡¥þ³¡OK
ÁÂÁ±zªº¼ö¤ßÀ°¦£¡C
·P®¦
=======================================
¤£¦n·N«ä¡A¦pªG±N¤½¦¡ªº±ø¥ó
§ï¬°
±NB4,B11,B18,B25¤¤ªº³Ì¤p­È¥B<30ªºÀx¦s®æ¼Ð¥Üºñ¦â¡C
±NB4,B11,B18,B25¤¤ªº³Ì¤p­È¼Ð¥Ü¶À¦â¡C
±NB4,B11,B18,B25¤¤<40ªºÀx¦s®æ¼Ð¥Ü²HÂŦâ¡C
¦p¤U¹Ï¡J
¥¼©R¦W.png
2019-12-4 15:43

§Ú±N¤½¦¡ªºMAX§ï¬°MIN
§Y
±ø¥ó1  =(MIN((MOD(ROW($425),7)=4)*B$4:B$25)=B4)*(MOD(ROW(B4),7)=4)*(B4<30)  ºñ¦â
±ø¥ó2  =(MIN((MOD(ROW($425),7)=4)*B$4:B$25)=B4)*(MOD(ROW(B4),7)=4)  ¶À¦â
±ø¥ó3  =(MOD(ROW(B4),7)=4)*(B4<40)  ÂŦâ
¥i¬O§Ú§ïªº¤½¦¡(½Ð¨£Sheet3)Åã¥Ü¤£¥X¦p¤W¹Ïªº¥¿½T©³¦â
¯à§_¦A³Ò¾r±z«ü¥¿?ÁÂÁ±z!

´ú¸ÕÀÉ¡J «ü©wÀx¦s®æ¼Ð¥ÜÃC¦â_Sheet3.rar (2.8 KB)

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2019-12-4 17:47 ½s¿è

±ø¥ó1  =(MIN(IF((MOD(ROW($4:$25),7)=4),B$4:B$25))=B4)*(MOD(ROW($4:$25),7)=4)*(B4<30))  ºñ¦â

±ø¥ó2=(MIN(IF((MOD(ROW($4:$25),7)=4),B$4:B$25))=B4)*(MOD(ROW($4:$25),7)=4)¶À¦â

±ø¥ó3  =(MOD(ROW(B4),7)=4)*(B4<40)  ÂŦâ

¦¸§Ç¨Ì²{¦³  ¥u§ï¤½¦¡ ®t§O +IF
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2019-12-4 18:59 ½s¿è

¦^´_ 4# hcm19522
¨þ~¨þ~ÁÙ¥H¬°±NMAX§ï¬°MIN§Y¥i~­ì¨Ó¨ä¤¤©|¦³«Ü²`ªº¾Ç°Ý
´ú¸ÕOK¤F!
ÁÂÁ±zªº¼ö¤ßÀ°¦£©M­@¤ß«ü¾É!·P®¦

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD