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

¦³ÃöIndex »P Lookup¦p¦ó¯à§ä¥X¨Ì¤j¤p¼g­­©wªº­È©O

²Ä1­Ó§¹¥þ¬Û¦P
=MATCH(,0/EXACT($D2,$B$2:$B$14),0)

³Ì«á1­Ó§¹¥þ¬Û¦P
=MATCH(,0/EXACT($D2,$B$2:$B$14),1)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# clio
°}¦C¤½¦¡¡A¿é¤J¤½¦¡­n¥Î¤TÁä¿é¤J

ÂI¿ï½s¿è¦C¤½¦¡
¥ý«ö¦í SHIFT+CTRL ¤£©ñ ¦A«öENTER ¿é¤J
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# clio


Match(,
µ¥¦P
Match(0,
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD