º¯°æÀü |
º¯°æÈÄ |
1 |
2 |
2 |
1 |
3 |
4 |
4 |
3 |
5 |
6 |
6 |
5 |
. |
. |
. |
. |
. |
. |
À§¿Í °°ÀÌ 1 -> 2, 2->1, 3->4, 4->3, 5->6, 6->5 ·Î ¹Ù²î¾î Áö°Ô ÇÏ°í ½ÍÀºµ¥,
°¡Àå °£Æí ÇÏ°Ô ÇÏ´Â ¹æ¹ýÀÌ ¹»±î¿ä?
INDIRECT ÇÔ¼ö ½á¼ 3,4´Ü°è °ÅÄ¡¸é µÇ±ä Çϴµ¥, °¡Àå °£´ÜÇÏ°Ô ÇÒ ¼ö ÀÖ´Â ¹æ¹ýÀÌ ¾øÀ»±î¿ä?
=============================================================
W205 |
W206 |
W206 |
W205 |
W223 |
W224 |
W224 |
W223 |
W20F |
W210 |
W210 |
W20F |
W22D |
W22E |
W22E |
W22D |
W219 |
W21A |
W21A |
W219 |
W237 |
W238 |
W238 |
W237 |
W269 |
W26A |
W26A |
W269 |
¿ø·¡ µ¥ÀÌÅÍ´Â À§¿Í °°Àº ÀÚ·áÀε¥,
=IF(MOD(ROW(),2)<>0,INDIRECT("A"&ROW()+1),INDIRECT("A"&ROW()-1))
±³ÁÖ»ç¶û´ÔÀÇ ´ñ±ÛÀ» ÂüÁ¶ÇÏ¿© À§¿Í °°Àº ¼ö½ÄÀ¸·Î ÇØ°á ÇÏ¿´½À´Ï´Ù.
°¨»çÇÕ´Ï´Ù.
![](skin/nzeo_bbs1/t.gif)
|