ªð¦^¦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 (11.77 KB)

°ÝÃ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

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

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD