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

27992931

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

ML089

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

¤U¸ü¦¸¼Æ: 10

2016-6-20 23:10

F2 =MAX(FREQUENCY(ROW($1:$98),ROW($1:$99)*(A$1:A$99&B$1:B$99<>$E2&F$1)))-1

zz5151353

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))))}

hcm19522

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

hcm19522

¦^´_ 3# zz5151353


    ¶K¤Wµ{¦¡«á ÀH¤§­«·s½s¿è ¤U­±¦³ "¸T¥Îªí±¡" §R¤S¦^´_ §Y¥i§Rªí±¡

zz5151353

¦^´_  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

ML089

¦^´_ 6# zz5151353

zz5151353¥S¡AÅwªï§A¡A¦n¤[¨S¦³ÅS­±¤F¡A§A¤@¨Ó½×¾Â´N¼ö¾x°_¨Ó¡C