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

[µo°Ý] ­pºâ­«½Æ¶µªº­Ó¼Æ»PSUBTOTAL¿z¿ï¤p­p¦@¥Îªº°ÝÃD

¦^´_ 3# pin_apple


{=COUNT(0/IF(SUBTOTAL(3,OFFSET(B1,ROW(B5:B620)-1,)),MATCH(A5:A620,A:A,)=ROW(5:620))) }
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ­ã´£³¡ªL
¦^´_ 1# pin_apple

§A¦Ò¼{ªº¤ñ¸û©P¨ì

­×¥¿¥HFREQUENCY³B²z¡A¤£¥Î°}¦C¤½¦¡¿é¤J¡Aª`·N¤½¦¡¨Ï¥Î®É½d³ò621¦C»Ý­n¥[1¬°620+1=621
=COUNT(0/FREQUENCY(ROW(5:621),SUBTOTAL(3,OFFSET(A1,ROW(A5:A620)-1,))*MATCH(A5:A620,A:A,)))-1
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD