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

[µo°Ý] ¹ï¨¤¤­¬q°Ï°ìªº³Ì¤j¼Æ

[µo°Ý] ¹ï¨¤¤­¬q°Ï°ìªº³Ì¤j¼Æ

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-12-17 04:07 ½s¿è


¹ï¨¤¤­¬q°Ï°ìªº³Ì¤j¼Æ.rar (6.4 KB)
»Ý¨D¡J
½Ð±N¦C62ªº5¬q¤½¦¡§ï¬°"¤@¦¡¥k©Ô"¡C
ÁÂÁ¡I

¤£¦n·N«ä¡A¤§«e¾Ç²ßªº³£¬O¨C­Ó°Ï¬qÄæ¦ì¼Æ¬°©T©w¼Æ(EX:5Äæ*9+4Äæ*1=¦@10­Ó°Ï¬q)¡A
¥»ÃD¬O¨C­Ó°Ï¬qªºÄæ¦ì¼Æ¬°«D©w¼Æ(8Äæ*1+12Äæ*1+10Äæ*2+9Äæ*1=¦@5­Ó°Ï¬q)¡F
ª¦¤å³\¤[¡A²@µL¶i®i
©|½Ð¦U¦ì¤j¤jÀ°¦£!ÁÂÁÂ!

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2020-12-18 14:37 ½s¿è

{=TEXT(MAX(OFFSET($A1,SMALL(IF($A3:$A60="¤p­p",ROW(3:60)),COUNTIF($B1:B1,"<>"))-1,LOOKUP(1,0/($B1:B1<>""),COLUMN($A:A)),,SUM(N(COUNTIF(OFFSET($B1,,,,COLUMN($A:$AW)),"<>")=COUNTIF($B1:B1,"<>"))))),"[="&N(OFFSET($A1,SMALL(IF($A3:$A60="¤p­p",ROW(3:60)),COUNTIF($B1:B1,"<>"))-1,COLUMN(A1)))&"]0;")


https://blog.xuite.net/hcm19522/twblog/589516855
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-12-18 16:29 ½s¿è

¦^´_ 3# hcm19522
h¤j¤j:±z¦n!
«D±`·P¿E±z½ç±Ðªº¤½¦¡³£¯à¾A¥Î©ó¥ô¦óÄæ¦ì¼Æ§Oªº°Ï¬q¡A
¥»ÃD©M«eÃDªº¤G¤½¦¡¡A§¹¥þ¸Ñ¨M¤Fªñ20­Ó¦]±Æ¦C§Ç§O¦Ó²£¥Íªº§xÂZ~¸U¤Àªº·P®¦®@

PS : °ß¤@ªº¤@­Ó¤p¿ò¾Ñ¬O¥»ÃD¤½¦¡ªºµª®×¬°¤å¦r§ÎºA¡A­n¦A¾Þ§@¨ä¥L»Ý¨D¡A´NµLªk¨Ï¥Î¤F~´Ý©À

TOP

¦^´_ 3# hcm19522
h¤j¤j :
¯uªº¤£¬O§Ú¤£ª¾¨¬~
¹ê¦b¤å¦r«¬¤½¦¡­È¤£¾A¦X§Ú©Ò¥Î~
¦]¬°­n´ú¸Õªñ100­ÓExcelÀɮסA©Ò¥H±N¤½¦¡µ{¦¡¤Æ¶K¨ì¥¨¶°§@¹Bºâ¡A
·í¤½¦¡­È¥²¶·¦A°µ¨ä¥¦¤ñ¹ï©Î®æ¦¡³]©w©Î­pºâ¡A¤å¦r«¬­È±`±`¤£¾A¥Î¡A
¤×¨ä¥»¸ÑÃD¤½¦¡¡A³s°õ¦æ³£²£¥Í°»¿ù¡A©Ò¥H§Q¥Î"Âà­È"¤]µL®Ä(¶]¤£¨ì"Âà­È"µ{¦¡¦C¡A´N¸õ¥X°»¿ù´£¥Ü®Ø)¡A
©Ò¥H¯à§_«_¬Nªº¦A³Ò¾r±z«ü¾É¼Æ­È«¬µª®×ªº¸ÑÃD¤½¦¡?
ÁÂÁ±z

TOP

¦^´_ 5# ziv976688


    {=IF(MAX((COUNTIF($B1:B1,"<>")=COUNTIF(OFFSET($B1,,,,COLUMN($A:$AW)),"<>"))*(SMALL(IF($A3:$A60="¤p­p",ROW(3:60)),COUNTIF($B1:B1,"<>"))=ROW(3:60))*$B3:$AX60)=N(OFFSET($A1,SMALL(IF($A3:$A60="¤p­p",ROW(3:60)),COUNTIF($B1:B1,"<>"))-1,COLUMN(A1))),OFFSET($A1,SMALL(IF($A3:$A60="¤p­p",ROW(3:60)),COUNTIF($B1:B1,"<>"))-1,COLUMN(A1)),"")

¤½¦¡«á¤å¥»¼Æ¦r­n¥Î (0&B62:AX62)*1 §Y¼Æ¦r
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 6# hcm19522
h¤j:
«D±`ÁÂÁ±zªº­@¤ß«ü¾É©MÀ°¦£¡C
°ÝÃD¥þ¸Ñ¨M¤F~·P®¦

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD