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

[µo°Ý] ¤£¦P«È¤á¤U³æ¼t§O²Î­p

=IF(SUMPRODUCT((DATA!$A$2:$A$31=LEFT(B$1))*(DATA!$C$2:$C$31=$A2)),"V","")

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD