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

[µo°Ý] ¦p¦ó§P©w®Æ¸¹+§å¸¹¨ä¥Í²£¤Ñ¼Æ

J2 =COUNT(0/FREQUENCY((G2=B$2:B$99)*(H2=C$2:C$99)*A$2:A$99,A$2-2+ROW($1:$99)))-1
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# jsc0518

¥Î§A­ì¨ÓªºÀÉ®×´ú¸Õ¬OOKªº¡A¸Ì­±¤]¦³2¤Ñ­«½Æ¥u­pºâ1¦¸
¦³·sªº´ú¸ÕÀɮ׶Ü?§Ú¬Ý¬Ý¸U´£¦b­þ¸Ì?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD