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

[µo°Ý] ªÅ¥Õ<>0­Èªº¨ç¼Æ¤½¦¡

C19 =INDEX(1:1,MATCH(C18,14:14,))

¨ú¥©
C19 =MATCH(C18,14:14,)-2
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

C18:AB19 °Ï°ì°}¦C¤½¦¡¡A±Æ¦C 14¦C¼Æ­È¥Ñ¤p¦Ü¤j¤Î1¦C¼Æ­È¥Ñ¤j¦Ü¤p
=IFERROR(INDEX(A:AY,{14;1},1/MOD(SMALL(IF(C14:AY14<>"",C14:AY14*10^4+1/COLUMN(C:AY)),COLUMN(A:Z)),10^4)),"")

¿é¤J¤½¦¡ (¥H«e°}¦C¤½¦¡­n¥ý§R°£)
1 ¥ý½Æ»s¤½¦¡
2 ¿ï¾Ü C18:AB19 Àx¦s®æ
3 ½s¿è¦C¶K¤W¤½¦¡
4 ¹«¼Ð¦ì©ó½s¿è¦C¡A¥Î¤TÁä(CTRL+SHIFT+ENTER)¿é¤J¤½¦¡


COLUMN(A:Z) ¨ú¥X´X­Ó¡A³Ì¤jÀ³¸Ó¬O¸ê®Æ¦³´XÄæ´N³]´XÄæ¡A¦ý¶K¤W(Åã¥Ü)Äæ¦ì¥i¥HÁYµu¦ÜªÅ®æ¥X²{1®æ¦ì¸m¡Aªí¥Ü¸ê®Æ§¹¥þ¥X²{¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

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