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

[µo°Ý] ½Ð°Ý«ç»ò­pºâ¨â¦æªº³Ì¤j³sÄò¦¸¼Æ©O

[µo°Ý] ½Ð°Ý«ç»ò­pºâ¨â¦æªº³Ì¤j³sÄò¦¸¼Æ©O

A¦æ¡A¤º®e¥]§t¥Ò¤A¤þ¡AB¦æ¡A¤º®e¥]§t¼Æ­È0©M1¡A§Ú­n«ç»ò¤À§O¨D¥Ò¤A¤þ¼Æ­È1ªº³Ì¤j³sÄò¦¸¼Æ©O¡H
¥Ò 1
¥Ò 1
¥Ò 0
¤A 1
¤A 1
¤A 1
¤þ 1
¤þ 1
¤þ 1
¤þ 1
¤þ 1

­pºâ¨â¦æªº³Ì¤j³sÄò¦¸¼Æ.rar (11.63 KB)

F2 =MAX(FREQUENCY(ROW($1:$98),ROW($1:$99)*(A$1:A$99&B$1:B$99<>$E2&F$1)))-1
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2017-6-26 10:08 ½s¿è

F2 ¥k©Ô¤Î¤U©Ô
{=MAX(FREQUENCY(IF($A$1:$A$11&$B$1:$B$11=$E2&F$1,ROW($1:$11)),IF($A$1:$A$11&$B$1:$B$11<>$E2&F$1,ROW($1:$11))))}

TOP

F2:F4{=MAX(FREQUENCY(IF((B$2:B$12=E2)*(C$2:C$12=1),ROW(B$2:B$12)),IF(B$2:B$12<>E2,ROW(B$2:B$12))))

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

TOP

¦^´_ 3# zz5151353


    ¶K¤Wµ{¦¡«á ÀH¤§­«·s½s¿è ¤U­±¦³ "¸T¥Îªí±¡" §R¤S¦^´_ §Y¥i§Rªí±¡
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_  zz5151353


    ¶K¤Wµ{¦¡«á ÀH¤§­«·s½s¿è ¤U­±¦³ "¸T¥Îªí±¡" §R¤S¦^´_ §Y¥i§Rªí±¡
hcm19522 µoªí©ó 2017-6-26 09:55


¦hÁÂhcm19522¥S¡A¤Ó¤[¨S¦^¨Ó½×¾Â¤]®tÂI³s¦Û¤v±K½X³£§Ö§Ñ¤F¡C
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 6# zz5151353

zz5151353¥S¡AÅwªï§A¡A¦n¤[¨S¦³ÅS­±¤F¡A§A¤@¨Ó½×¾Â´N¼ö¾x°_¨Ó¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD