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

[µo°Ý] Åã¥Ü¯Á¤Þ­È

[µo°Ý] Åã¥Ü¯Á¤Þ­È

ªþ¥ó¡G Åã¥Ü¯Á¤Þ­È.rar (3.04 KB)
³Æµù¡G
1_A2¡GAnªº¼Æ¦r·|¦³­«½Æ¡C
2_$C$2:$AO$6ªº¼Æ¦r=1~39¥B¤£·|¦³­«½Æ¡C


·íA2<>""®É¡A«hB2Åã¥Ü$C$2:$AO$6¦³A2­Èªº¦PÄ椧²Ä1¦C­È¡C
½Ð°Ý¡JB2¤@¦¡¤U©Ô¨ì¦ìªº¨ç¼Æ¤½¦¡À³¦p¦ó½s¼g¡H
ÁÂÁ¡I

¦^´_ 2# samwang
·PÁ±zªº«ü¾É

TOP

¦^´_ 1# papaya

B2  {=INDEX($A$1:$AO$1,,SMALL(IF(($C$2:$AO$6=A2),COLUMN(C:AO),9999),ROW($A$1)))}

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD