![]() |
![]() |
||||
|
|||||
![]() |
![]() |
Excel ¿¡¼ Sequance¿¡ µû¶ó A~Z ¸¦ Á¶ÇÕÇÑ ³ª¿À» ¸¸µå´Âµ¥... À½... ¼ö½Ä¸¸ °¡Áö°í ¸¸µé´Ù º¸´Ï ±×·±°ÇÁö... ¿µ ¼ö½ÄÀÌ ÁöÀúºÐ Çϳ׿ä... ¤Ð¤Ì ÀÌ°Å ´Ü¼øÈ ½Ãų ¹æ¹ýÀÌ ÀÖÀ»±î¿ä? ![]() ¼ö½ÄÀº ¾Æ·¡¿Í °°ÀÌ »ç¿ëÇß½À´Ï´Ù. ![]() À½... ÅؽºÆ®µµ Ãß°¡ÇÕ´Ï´Ù. = IF(AND(INT(B2/26)>0,MOD(B2,26)>0), CHAR(64+INT(B2/26)), IF(AND(INT(B2/26)>0,B2>26), CHAR(64+INT(B2/26)-1), " " ) ) & CHAR(64+ IF(B2<=26, B2, B2- IF(26*INT(B2/26)=B2, 26*(INT(B2/26)-1), 26*INT(B2/26) ) ) ) ÀÌ°Å Á¶±Ý´õ ´Ùµë¾î¼ ÀÌ»Ú°Ô ¸¸µé°í ½ÍÀºµ¥... ¿¢¼¿ ÇÔ¼ö·Î¸¸ ¸¸µå´Â°Ô ½±Áö ¾Ê³×¿ä ¤Ð¤Ì ![]() |
|
![]() |
||
![]() |
||
| ||
![]() |
||
![]() |
||
![]() |
||
| ||
![]() |
||
![]() |
||
![]() |
||
| ||
![]() |