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

[µo°Ý] MATCH + ¤j¤p¼g°ÝÃD½Ð±Ð

C1¿é¤J "A" ©Î "a"

{=MATCH(,0/EXACT(C1,A:A),)}
{...} °}¦C¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# rouber590324

°Ñ¦ÒÀÉ®×
    MATCH + ¤j¤p¼g°ÝÃD½Ð±Ð.rar (6.26 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD