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

[µo°Ý] ¥H¤ë¥÷²Î­p¤£­«½Æ«È¤á¼Æ

[µo°Ý] ¥H¤ë¥÷²Î­p¤£­«½Æ«È¤á¼Æ

½Ð°Ý¦p¦ó¥Î¤ë¥÷¥h²Î­p«È¤á¼Æ¡A¦pªþªí3¤ëªº¤£­«½Æ«È¤á¼Æ¬°7®a¡A¦p¦ó¥Î¤½¦¡¦bE7±o¨ì7®aªº­È©O¡H
­ì¥ý¥´ºâ¦Û¤v¥Î­Ó°Ï¶¡¥h²Î­p«È¤á¼Æ¡A¦ýªÅ¥Õ¤Ó¦h±o¨ìªº­È¤@ª½¬O¿ù»~ªº¡A¤W¨Ó°Ý°Ý¬Ý¤j®a¡AÁÂÁÂ
°ÝÃD.PNG

E2 =COUNT(0/FREQUENCY(IF(TEXT(A3:A99,"m;;0")="3",MATCH(B3:B99,B:B,),0),ROW(3:99)))
°}¦C¤½¦¡
CTRL+SHIFT+ENTER¿é¤J¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD