{"id":600,"date":"2024-02-20T23:04:37","date_gmt":"2024-02-20T14:04:37","guid":{"rendered":"https:\/\/exceljump.com\/?p=600"},"modified":"2024-02-20T23:04:44","modified_gmt":"2024-02-20T14:04:44","slug":"%ec%97%91%ec%85%80-tocol","status":"publish","type":"post","link":"https:\/\/exceljump.com\/%ec%97%91%ec%85%80-tocol\/","title":{"rendered":"\uc5d1\uc140 \ub370\uc774\ud130 \ud55c\uc5f4\ub85c, \ud55c\uc904\ub85c \uc815\ub82c\ud558\ub294 \ubc29\ubc95(TOCOL \ud568\uc218)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"\n
\uc5d1\uc140 TOCOL \ud568\uc218 – \ud14c\uc774\ube14\ub85c \uc774\ub8e8\uc5b4\uc9c4 \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\uae30 \uc704\ud574 \ub300\ud45c\uc801\uc778 \uc5d1\uc140\uc758 \ubcf5\uc0ac \ubd99\uc5ec\ub123\uae30 \ub2e8\ucd95\ud0a4<\/a><\/strong>\ub97c \uc0ac\uc6a9\ud560 \uac81\ub2c8\ub2e4. \ud558\uc9c0\ub9cc TOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uc190\uc27d\uac8c \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c \uc904\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure><\/div>\n\n\n\n\nCONTENTS<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n \uc5d1\uc140 TOCOL \ud568\uc218\ub780?<\/a> \ud568\uc218\uad6c\ubb38<\/a><\/li><\/ul><\/li> \uc5d1\uc140 TOCOL \ud568\uc218 \uc608\uc81c<\/a> TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\uc5f4 \ubc29\ud5a5)<\/a><\/li> TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ud589 \ubc29\ud5a5)<\/a><\/li> TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ube48\uce78 \ub610\ub294 0\uc758 \uac12)<\/a><\/li><\/ul><\/li>\uacb0\ub860<\/a><\/li><\/ul><\/nav><\/div>\n<\/span>\uc5d1\uc140 TOCOL \ud568\uc218\ub780?<\/strong><\/span><\/h2>\n\n\n\n\ud68c\uc0ac \uc5d1\uc140\uc744 \uc0ac\uc6a9\ud558\ub2e4 \ubcf4\uba74 \uc5ec\ub7ec \uac12\uc744 \ud55c \uc904\ub85c \ub9cc\ub4e4 \ub54c\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uadf8 \uacbd\uc6b0 \uc6b0\ub9ac\ub294 \uc8fc\ub85c \uc5d1\uc140 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uadf8\ub7f0 \uc774\uc720\ub85c TOCOL \ud568\uc218\uc758 \uc874\uc7ac \uc790\uccb4\uac00 \uc775\uc219\ud558\uc9c0 \uc54a\uc744 \uac81\ub2c8\ub2e4. <\/p>\n\n\n\n\uc5d1\uc140 \uc5ec\ub7ec \uc5f4\uc744 \ud55c\uc5f4\ub85c \ub9cc\ub4dc\ub294 \ud568\uc218\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<\/span>\ud568\uc218\uad6c\ubb38<\/strong><\/span><\/h3>\n\n\n\n\uc5d1\uc140 TOCOL \ud568\uc218\uad6c\ubb38\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n=TOCOL(ARRAY,[ignore],[scan_by_column])<\/mark><\/strong><\/p>\n\n\n\n\nARRAY : \ub370\uc774\ud130\uc758 \ubc94\uc704\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/li>\n\n\n\nIgnore : \ud55c \uc904\ub85c \uc815\ub82c\ud560 \ub54c \uc22b\uc790 0 \ub610\ub294 \uacf5\ub780\uc5d0 \ub300\ud574 \ud3ec\ud568 \uc720\ubb34\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n\n\n\nScan_by_column : \ub370\uc774\ud130\uc758 \ud55c \uc904 \uc815\ub82c \uc21c\uc11c\ub97c \ud589\uacfc \uc5f4\uc758 \ubc29\ud5a5\uc73c\ub85c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<\/span>\uc5d1\uc140 TOCOL \ud568\uc218 \uc608\uc81c<\/strong><\/span><\/h2>\n\n\n\nTOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\ub294 \uba87\uac00\uc9c0 \uc608\uc81c\ub97c \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n\uc6b0\uc120 \uc544\ub798\uc640 \uac19\uc774 B\uc5f4\uacfc E\uc5f4\uc5d0 \ud14c\uc774\ube14 \ud615\uc2dd\uc758 \ub370\uc774\ud130\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\uc5f4 \ubc29\ud5a5)<\/strong><\/span><\/h3>\n\n\n\n\uc808\ub300\ucc38\uc870<\/a><\/strong>\ub97c \ud65c\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc758 \ubc94\uc704\ub97c \uace0\uc815\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<\/figure>\n\n\n\n\uc544\ub798\uc640 \uac19\uc740 \ud568\uc218\uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \ubc94\uc704\uc758 \ub370\uc774\ud130\ub97c \ud55c \uc5f4\ub85c \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ud589 \ubc29\ud5a5)<\/strong><\/span><\/h3>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \uc815\ub82c \ubc29\uc2dd\uc744 \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud589\ubc29\ud5a5\uc73c\ub85c \uac00\uc838\uc635\ub2c8\ub2e4. <\/p>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>0<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ube48\uce78 \ub610\ub294 0\uc758 \uac12)<\/strong><\/span><\/h3>\n\n\n\n\ud55c \uc904\ub85c \uc815\ub82c\uc744 \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc5d0 \ube48\uce78 \ub610\ub294 0\uc758 \uac12\uc774 \uc788\uc744 \uacbd\uc6b0, \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \uac12\ub9cc \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>1<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>\uacb0\ub860<\/strong><\/span><\/h2>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \ubcc0\ud658\uc740 \uc0b0\ucd9c\ud558\uace0\uc790 \ud558\ub294 \uac12\uc744 \uad6c\ud558\ub294 \uccab\ubc88\uc9f8 \ub2e8\uacc4\uc785\ub2c8\ub2e4. \uc5d1\uc140 \ub370\uc774\ud130 \uc815\ub82c\uc740 \ub9ce\uc740 \ubc29\ubc95\ub4e4\uc774 \uc788\uc9c0\ub9cc \ub370\uc774\ud130\uc758 \uc591\uc5d0 \ub530\ub77c \uc0c1\ud669\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"\uc5d1\uc140 TOCOL \ud568\uc218 – \ud14c\uc774\ube14\ub85c \uc774\ub8e8\uc5b4\uc9c4 \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\uae30 \uc704\ud574 \ub300\ud45c\uc801\uc778 \uc5d1\uc140\uc758 \ubcf5\uc0ac \ubd99\uc5ec\ub123\uae30 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud560 \uac81\ub2c8\ub2e4. \ud558\uc9c0\ub9cc TOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uc190\uc27d\uac8c \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c \uc904\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. …<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[506,507,500,511,501,502,505,510,504,503,508,509],"jetpack_publicize_connections":[],"yoast_head":"\n\uc5d1\uc140 \ub370\uc774\ud130 \ud55c\uc5f4\ub85c, \ud55c\uc904\ub85c \uc815\ub82c\ud558\ub294 \ubc29\ubc95(TOCOL \ud568\uc218)<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\t\n\t\n\t\n
CONTENTS<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n \uc5d1\uc140 TOCOL \ud568\uc218\ub780?<\/a> \ud568\uc218\uad6c\ubb38<\/a><\/li><\/ul><\/li> \uc5d1\uc140 TOCOL \ud568\uc218 \uc608\uc81c<\/a> TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\uc5f4 \ubc29\ud5a5)<\/a><\/li> TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ud589 \ubc29\ud5a5)<\/a><\/li> TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ube48\uce78 \ub610\ub294 0\uc758 \uac12)<\/a><\/li><\/ul><\/li>\uacb0\ub860<\/a><\/li><\/ul><\/nav><\/div>\n<\/span>\uc5d1\uc140 TOCOL \ud568\uc218\ub780?<\/strong><\/span><\/h2>\n\n\n\n\ud68c\uc0ac \uc5d1\uc140\uc744 \uc0ac\uc6a9\ud558\ub2e4 \ubcf4\uba74 \uc5ec\ub7ec \uac12\uc744 \ud55c \uc904\ub85c \ub9cc\ub4e4 \ub54c\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uadf8 \uacbd\uc6b0 \uc6b0\ub9ac\ub294 \uc8fc\ub85c \uc5d1\uc140 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uadf8\ub7f0 \uc774\uc720\ub85c TOCOL \ud568\uc218\uc758 \uc874\uc7ac \uc790\uccb4\uac00 \uc775\uc219\ud558\uc9c0 \uc54a\uc744 \uac81\ub2c8\ub2e4. <\/p>\n\n\n\n\uc5d1\uc140 \uc5ec\ub7ec \uc5f4\uc744 \ud55c\uc5f4\ub85c \ub9cc\ub4dc\ub294 \ud568\uc218\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<\/span>\ud568\uc218\uad6c\ubb38<\/strong><\/span><\/h3>\n\n\n\n\uc5d1\uc140 TOCOL \ud568\uc218\uad6c\ubb38\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n=TOCOL(ARRAY,[ignore],[scan_by_column])<\/mark><\/strong><\/p>\n\n\n\n\nARRAY : \ub370\uc774\ud130\uc758 \ubc94\uc704\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/li>\n\n\n\nIgnore : \ud55c \uc904\ub85c \uc815\ub82c\ud560 \ub54c \uc22b\uc790 0 \ub610\ub294 \uacf5\ub780\uc5d0 \ub300\ud574 \ud3ec\ud568 \uc720\ubb34\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n\n\n\nScan_by_column : \ub370\uc774\ud130\uc758 \ud55c \uc904 \uc815\ub82c \uc21c\uc11c\ub97c \ud589\uacfc \uc5f4\uc758 \ubc29\ud5a5\uc73c\ub85c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<\/span>\uc5d1\uc140 TOCOL \ud568\uc218 \uc608\uc81c<\/strong><\/span><\/h2>\n\n\n\nTOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\ub294 \uba87\uac00\uc9c0 \uc608\uc81c\ub97c \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n\uc6b0\uc120 \uc544\ub798\uc640 \uac19\uc774 B\uc5f4\uacfc E\uc5f4\uc5d0 \ud14c\uc774\ube14 \ud615\uc2dd\uc758 \ub370\uc774\ud130\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\uc5f4 \ubc29\ud5a5)<\/strong><\/span><\/h3>\n\n\n\n\uc808\ub300\ucc38\uc870<\/a><\/strong>\ub97c \ud65c\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc758 \ubc94\uc704\ub97c \uace0\uc815\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<\/figure>\n\n\n\n\uc544\ub798\uc640 \uac19\uc740 \ud568\uc218\uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \ubc94\uc704\uc758 \ub370\uc774\ud130\ub97c \ud55c \uc5f4\ub85c \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ud589 \ubc29\ud5a5)<\/strong><\/span><\/h3>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \uc815\ub82c \ubc29\uc2dd\uc744 \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud589\ubc29\ud5a5\uc73c\ub85c \uac00\uc838\uc635\ub2c8\ub2e4. <\/p>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>0<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ube48\uce78 \ub610\ub294 0\uc758 \uac12)<\/strong><\/span><\/h3>\n\n\n\n\ud55c \uc904\ub85c \uc815\ub82c\uc744 \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc5d0 \ube48\uce78 \ub610\ub294 0\uc758 \uac12\uc774 \uc788\uc744 \uacbd\uc6b0, \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \uac12\ub9cc \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>1<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>\uacb0\ub860<\/strong><\/span><\/h2>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \ubcc0\ud658\uc740 \uc0b0\ucd9c\ud558\uace0\uc790 \ud558\ub294 \uac12\uc744 \uad6c\ud558\ub294 \uccab\ubc88\uc9f8 \ub2e8\uacc4\uc785\ub2c8\ub2e4. \uc5d1\uc140 \ub370\uc774\ud130 \uc815\ub82c\uc740 \ub9ce\uc740 \ubc29\ubc95\ub4e4\uc774 \uc788\uc9c0\ub9cc \ub370\uc774\ud130\uc758 \uc591\uc5d0 \ub530\ub77c \uc0c1\ud669\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"\uc5d1\uc140 TOCOL \ud568\uc218 – \ud14c\uc774\ube14\ub85c \uc774\ub8e8\uc5b4\uc9c4 \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\uae30 \uc704\ud574 \ub300\ud45c\uc801\uc778 \uc5d1\uc140\uc758 \ubcf5\uc0ac \ubd99\uc5ec\ub123\uae30 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud560 \uac81\ub2c8\ub2e4. \ud558\uc9c0\ub9cc TOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uc190\uc27d\uac8c \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c \uc904\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. …<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[506,507,500,511,501,502,505,510,504,503,508,509],"jetpack_publicize_connections":[],"yoast_head":"\n\uc5d1\uc140 \ub370\uc774\ud130 \ud55c\uc5f4\ub85c, \ud55c\uc904\ub85c \uc815\ub82c\ud558\ub294 \ubc29\ubc95(TOCOL \ud568\uc218)<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\t\n\t\n\t\n
\ud68c\uc0ac \uc5d1\uc140\uc744 \uc0ac\uc6a9\ud558\ub2e4 \ubcf4\uba74 \uc5ec\ub7ec \uac12\uc744 \ud55c \uc904\ub85c \ub9cc\ub4e4 \ub54c\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uadf8 \uacbd\uc6b0 \uc6b0\ub9ac\ub294 \uc8fc\ub85c \uc5d1\uc140 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uadf8\ub7f0 \uc774\uc720\ub85c TOCOL \ud568\uc218\uc758 \uc874\uc7ac \uc790\uccb4\uac00 \uc775\uc219\ud558\uc9c0 \uc54a\uc744 \uac81\ub2c8\ub2e4. <\/p>\n\n\n\n
\uc5d1\uc140 \uc5ec\ub7ec \uc5f4\uc744 \ud55c\uc5f4\ub85c \ub9cc\ub4dc\ub294 \ud568\uc218\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
\uc5d1\uc140 TOCOL \ud568\uc218\uad6c\ubb38\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n
=TOCOL(ARRAY,[ignore],[scan_by_column])<\/mark><\/strong><\/p>\n\n\n\n\nARRAY : \ub370\uc774\ud130\uc758 \ubc94\uc704\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/li>\n\n\n\nIgnore : \ud55c \uc904\ub85c \uc815\ub82c\ud560 \ub54c \uc22b\uc790 0 \ub610\ub294 \uacf5\ub780\uc5d0 \ub300\ud574 \ud3ec\ud568 \uc720\ubb34\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n\n\n\nScan_by_column : \ub370\uc774\ud130\uc758 \ud55c \uc904 \uc815\ub82c \uc21c\uc11c\ub97c \ud589\uacfc \uc5f4\uc758 \ubc29\ud5a5\uc73c\ub85c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<\/span>\uc5d1\uc140 TOCOL \ud568\uc218 \uc608\uc81c<\/strong><\/span><\/h2>\n\n\n\nTOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\ub294 \uba87\uac00\uc9c0 \uc608\uc81c\ub97c \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n\uc6b0\uc120 \uc544\ub798\uc640 \uac19\uc774 B\uc5f4\uacfc E\uc5f4\uc5d0 \ud14c\uc774\ube14 \ud615\uc2dd\uc758 \ub370\uc774\ud130\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\uc5f4 \ubc29\ud5a5)<\/strong><\/span><\/h3>\n\n\n\n\uc808\ub300\ucc38\uc870<\/a><\/strong>\ub97c \ud65c\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc758 \ubc94\uc704\ub97c \uace0\uc815\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<\/figure>\n\n\n\n\uc544\ub798\uc640 \uac19\uc740 \ud568\uc218\uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \ubc94\uc704\uc758 \ub370\uc774\ud130\ub97c \ud55c \uc5f4\ub85c \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ud589 \ubc29\ud5a5)<\/strong><\/span><\/h3>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \uc815\ub82c \ubc29\uc2dd\uc744 \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud589\ubc29\ud5a5\uc73c\ub85c \uac00\uc838\uc635\ub2c8\ub2e4. <\/p>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>0<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ube48\uce78 \ub610\ub294 0\uc758 \uac12)<\/strong><\/span><\/h3>\n\n\n\n\ud55c \uc904\ub85c \uc815\ub82c\uc744 \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc5d0 \ube48\uce78 \ub610\ub294 0\uc758 \uac12\uc774 \uc788\uc744 \uacbd\uc6b0, \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \uac12\ub9cc \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>1<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>\uacb0\ub860<\/strong><\/span><\/h2>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \ubcc0\ud658\uc740 \uc0b0\ucd9c\ud558\uace0\uc790 \ud558\ub294 \uac12\uc744 \uad6c\ud558\ub294 \uccab\ubc88\uc9f8 \ub2e8\uacc4\uc785\ub2c8\ub2e4. \uc5d1\uc140 \ub370\uc774\ud130 \uc815\ub82c\uc740 \ub9ce\uc740 \ubc29\ubc95\ub4e4\uc774 \uc788\uc9c0\ub9cc \ub370\uc774\ud130\uc758 \uc591\uc5d0 \ub530\ub77c \uc0c1\ud669\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"\uc5d1\uc140 TOCOL \ud568\uc218 – \ud14c\uc774\ube14\ub85c \uc774\ub8e8\uc5b4\uc9c4 \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\uae30 \uc704\ud574 \ub300\ud45c\uc801\uc778 \uc5d1\uc140\uc758 \ubcf5\uc0ac \ubd99\uc5ec\ub123\uae30 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud560 \uac81\ub2c8\ub2e4. \ud558\uc9c0\ub9cc TOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uc190\uc27d\uac8c \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c \uc904\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. …<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[506,507,500,511,501,502,505,510,504,503,508,509],"jetpack_publicize_connections":[],"yoast_head":"\n\uc5d1\uc140 \ub370\uc774\ud130 \ud55c\uc5f4\ub85c, \ud55c\uc904\ub85c \uc815\ub82c\ud558\ub294 \ubc29\ubc95(TOCOL \ud568\uc218)<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\t\n\t\n\t\n
TOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\ub294 \uba87\uac00\uc9c0 \uc608\uc81c\ub97c \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
\uc6b0\uc120 \uc544\ub798\uc640 \uac19\uc774 B\uc5f4\uacfc E\uc5f4\uc5d0 \ud14c\uc774\ube14 \ud615\uc2dd\uc758 \ub370\uc774\ud130\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\uc5f4 \ubc29\ud5a5)<\/strong><\/span><\/h3>\n\n\n\n\uc808\ub300\ucc38\uc870<\/a><\/strong>\ub97c \ud65c\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc758 \ubc94\uc704\ub97c \uace0\uc815\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<\/figure>\n\n\n\n\uc544\ub798\uc640 \uac19\uc740 \ud568\uc218\uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \ubc94\uc704\uc758 \ub370\uc774\ud130\ub97c \ud55c \uc5f4\ub85c \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ud589 \ubc29\ud5a5)<\/strong><\/span><\/h3>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \uc815\ub82c \ubc29\uc2dd\uc744 \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud589\ubc29\ud5a5\uc73c\ub85c \uac00\uc838\uc635\ub2c8\ub2e4. <\/p>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>0<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ube48\uce78 \ub610\ub294 0\uc758 \uac12)<\/strong><\/span><\/h3>\n\n\n\n\ud55c \uc904\ub85c \uc815\ub82c\uc744 \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc5d0 \ube48\uce78 \ub610\ub294 0\uc758 \uac12\uc774 \uc788\uc744 \uacbd\uc6b0, \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \uac12\ub9cc \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>1<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>\uacb0\ub860<\/strong><\/span><\/h2>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \ubcc0\ud658\uc740 \uc0b0\ucd9c\ud558\uace0\uc790 \ud558\ub294 \uac12\uc744 \uad6c\ud558\ub294 \uccab\ubc88\uc9f8 \ub2e8\uacc4\uc785\ub2c8\ub2e4. \uc5d1\uc140 \ub370\uc774\ud130 \uc815\ub82c\uc740 \ub9ce\uc740 \ubc29\ubc95\ub4e4\uc774 \uc788\uc9c0\ub9cc \ub370\uc774\ud130\uc758 \uc591\uc5d0 \ub530\ub77c \uc0c1\ud669\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"\uc5d1\uc140 TOCOL \ud568\uc218 – \ud14c\uc774\ube14\ub85c \uc774\ub8e8\uc5b4\uc9c4 \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\uae30 \uc704\ud574 \ub300\ud45c\uc801\uc778 \uc5d1\uc140\uc758 \ubcf5\uc0ac \ubd99\uc5ec\ub123\uae30 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud560 \uac81\ub2c8\ub2e4. \ud558\uc9c0\ub9cc TOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uc190\uc27d\uac8c \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c \uc904\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. …<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[506,507,500,511,501,502,505,510,504,503,508,509],"jetpack_publicize_connections":[],"yoast_head":"\n\uc5d1\uc140 \ub370\uc774\ud130 \ud55c\uc5f4\ub85c, \ud55c\uc904\ub85c \uc815\ub82c\ud558\ub294 \ubc29\ubc95(TOCOL \ud568\uc218)<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\t\n\t\n\t\n
<\/p>\n\n\n\n
\uc808\ub300\ucc38\uc870<\/a><\/strong>\ub97c \ud65c\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc758 \ubc94\uc704\ub97c \uace0\uc815\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<\/figure>\n\n\n\n\uc544\ub798\uc640 \uac19\uc740 \ud568\uc218\uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \ubc94\uc704\uc758 \ub370\uc774\ud130\ub97c \ud55c \uc5f4\ub85c \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ud589 \ubc29\ud5a5)<\/strong><\/span><\/h3>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \uc815\ub82c \ubc29\uc2dd\uc744 \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud589\ubc29\ud5a5\uc73c\ub85c \uac00\uc838\uc635\ub2c8\ub2e4. <\/p>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>0<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ube48\uce78 \ub610\ub294 0\uc758 \uac12)<\/strong><\/span><\/h3>\n\n\n\n\ud55c \uc904\ub85c \uc815\ub82c\uc744 \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc5d0 \ube48\uce78 \ub610\ub294 0\uc758 \uac12\uc774 \uc788\uc744 \uacbd\uc6b0, \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \uac12\ub9cc \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>1<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>\uacb0\ub860<\/strong><\/span><\/h2>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \ubcc0\ud658\uc740 \uc0b0\ucd9c\ud558\uace0\uc790 \ud558\ub294 \uac12\uc744 \uad6c\ud558\ub294 \uccab\ubc88\uc9f8 \ub2e8\uacc4\uc785\ub2c8\ub2e4. \uc5d1\uc140 \ub370\uc774\ud130 \uc815\ub82c\uc740 \ub9ce\uc740 \ubc29\ubc95\ub4e4\uc774 \uc788\uc9c0\ub9cc \ub370\uc774\ud130\uc758 \uc591\uc5d0 \ub530\ub77c \uc0c1\ud669\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"\uc5d1\uc140 TOCOL \ud568\uc218 – \ud14c\uc774\ube14\ub85c \uc774\ub8e8\uc5b4\uc9c4 \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\uae30 \uc704\ud574 \ub300\ud45c\uc801\uc778 \uc5d1\uc140\uc758 \ubcf5\uc0ac \ubd99\uc5ec\ub123\uae30 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud560 \uac81\ub2c8\ub2e4. \ud558\uc9c0\ub9cc TOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uc190\uc27d\uac8c \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c \uc904\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. …<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[506,507,500,511,501,502,505,510,504,503,508,509],"jetpack_publicize_connections":[],"yoast_head":"\n\uc5d1\uc140 \ub370\uc774\ud130 \ud55c\uc5f4\ub85c, \ud55c\uc904\ub85c \uc815\ub82c\ud558\ub294 \ubc29\ubc95(TOCOL \ud568\uc218)<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\t\n\t\n\t\n
\uc544\ub798\uc640 \uac19\uc740 \ud568\uc218\uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud574\ub2f9 \ubc94\uc704\uc758 \ub370\uc774\ud130\ub97c \ud55c \uc5f4\ub85c \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
G3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ud589 \ubc29\ud5a5)<\/strong><\/span><\/h3>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \uc815\ub82c \ubc29\uc2dd\uc744 \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud589\ubc29\ud5a5\uc73c\ub85c \uac00\uc838\uc635\ub2c8\ub2e4. <\/p>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>0<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ube48\uce78 \ub610\ub294 0\uc758 \uac12)<\/strong><\/span><\/h3>\n\n\n\n\ud55c \uc904\ub85c \uc815\ub82c\uc744 \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc5d0 \ube48\uce78 \ub610\ub294 0\uc758 \uac12\uc774 \uc788\uc744 \uacbd\uc6b0, \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \uac12\ub9cc \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>1<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>\uacb0\ub860<\/strong><\/span><\/h2>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \ubcc0\ud658\uc740 \uc0b0\ucd9c\ud558\uace0\uc790 \ud558\ub294 \uac12\uc744 \uad6c\ud558\ub294 \uccab\ubc88\uc9f8 \ub2e8\uacc4\uc785\ub2c8\ub2e4. \uc5d1\uc140 \ub370\uc774\ud130 \uc815\ub82c\uc740 \ub9ce\uc740 \ubc29\ubc95\ub4e4\uc774 \uc788\uc9c0\ub9cc \ub370\uc774\ud130\uc758 \uc591\uc5d0 \ub530\ub77c \uc0c1\ud669\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"\uc5d1\uc140 TOCOL \ud568\uc218 – \ud14c\uc774\ube14\ub85c \uc774\ub8e8\uc5b4\uc9c4 \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\uae30 \uc704\ud574 \ub300\ud45c\uc801\uc778 \uc5d1\uc140\uc758 \ubcf5\uc0ac \ubd99\uc5ec\ub123\uae30 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud560 \uac81\ub2c8\ub2e4. \ud558\uc9c0\ub9cc TOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uc190\uc27d\uac8c \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c \uc904\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. …<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[506,507,500,511,501,502,505,510,504,503,508,509],"jetpack_publicize_connections":[],"yoast_head":"\n\uc5d1\uc140 \ub370\uc774\ud130 \ud55c\uc5f4\ub85c, \ud55c\uc904\ub85c \uc815\ub82c\ud558\ub294 \ubc29\ubc95(TOCOL \ud568\uc218)<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\t\n\t\n\t\n
\uc5d1\uc140 \ub370\uc774\ud130\uc758 \uc815\ub82c \ubc29\uc2dd\uc744 \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud589\ubc29\ud5a5\uc73c\ub85c \uac00\uc838\uc635\ub2c8\ub2e4. <\/p>\n\n\n\n
G3 cell =TOCOL($B$3:$E$5,<\/mark>0<\/mark>,<\/mark>0<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>TOCOL \ud568\uc218 \ud65c\uc6a9 \uc608\uc81c(\ube48\uce78 \ub610\ub294 0\uc758 \uac12)<\/strong><\/span><\/h3>\n\n\n\n\ud55c \uc904\ub85c \uc815\ub82c\uc744 \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc5d0 \ube48\uce78 \ub610\ub294 0\uc758 \uac12\uc774 \uc788\uc744 \uacbd\uc6b0, \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \uac12\ub9cc \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>1<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>\uacb0\ub860<\/strong><\/span><\/h2>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \ubcc0\ud658\uc740 \uc0b0\ucd9c\ud558\uace0\uc790 \ud558\ub294 \uac12\uc744 \uad6c\ud558\ub294 \uccab\ubc88\uc9f8 \ub2e8\uacc4\uc785\ub2c8\ub2e4. \uc5d1\uc140 \ub370\uc774\ud130 \uc815\ub82c\uc740 \ub9ce\uc740 \ubc29\ubc95\ub4e4\uc774 \uc788\uc9c0\ub9cc \ub370\uc774\ud130\uc758 \uc591\uc5d0 \ub530\ub77c \uc0c1\ud669\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"\uc5d1\uc140 TOCOL \ud568\uc218 – \ud14c\uc774\ube14\ub85c \uc774\ub8e8\uc5b4\uc9c4 \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\uae30 \uc704\ud574 \ub300\ud45c\uc801\uc778 \uc5d1\uc140\uc758 \ubcf5\uc0ac \ubd99\uc5ec\ub123\uae30 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud560 \uac81\ub2c8\ub2e4. \ud558\uc9c0\ub9cc TOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uc190\uc27d\uac8c \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c \uc904\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. …<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[506,507,500,511,501,502,505,510,504,503,508,509],"jetpack_publicize_connections":[],"yoast_head":"\n\uc5d1\uc140 \ub370\uc774\ud130 \ud55c\uc5f4\ub85c, \ud55c\uc904\ub85c \uc815\ub82c\ud558\ub294 \ubc29\ubc95(TOCOL \ud568\uc218)<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\t\n\t\n\t\n
\ud55c \uc904\ub85c \uc815\ub82c\uc744 \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc5d0 \ube48\uce78 \ub610\ub294 0\uc758 \uac12\uc774 \uc788\uc744 \uacbd\uc6b0, \uc544\ub798\uc758 \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc6d0\ud558\ub294 \uac12\ub9cc \uc815\ub82c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<\/figure>\n\n\n\nG3 cell =TOCOL($B$3:$E$5,<\/mark>1<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>\uacb0\ub860<\/strong><\/span><\/h2>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \ubcc0\ud658\uc740 \uc0b0\ucd9c\ud558\uace0\uc790 \ud558\ub294 \uac12\uc744 \uad6c\ud558\ub294 \uccab\ubc88\uc9f8 \ub2e8\uacc4\uc785\ub2c8\ub2e4. \uc5d1\uc140 \ub370\uc774\ud130 \uc815\ub82c\uc740 \ub9ce\uc740 \ubc29\ubc95\ub4e4\uc774 \uc788\uc9c0\ub9cc \ub370\uc774\ud130\uc758 \uc591\uc5d0 \ub530\ub77c \uc0c1\ud669\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"\uc5d1\uc140 TOCOL \ud568\uc218 – \ud14c\uc774\ube14\ub85c \uc774\ub8e8\uc5b4\uc9c4 \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\uae30 \uc704\ud574 \ub300\ud45c\uc801\uc778 \uc5d1\uc140\uc758 \ubcf5\uc0ac \ubd99\uc5ec\ub123\uae30 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud560 \uac81\ub2c8\ub2e4. \ud558\uc9c0\ub9cc TOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uc190\uc27d\uac8c \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c \uc904\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. …<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[506,507,500,511,501,502,505,510,504,503,508,509],"jetpack_publicize_connections":[],"yoast_head":"\n\uc5d1\uc140 \ub370\uc774\ud130 \ud55c\uc5f4\ub85c, \ud55c\uc904\ub85c \uc815\ub82c\ud558\ub294 \ubc29\ubc95(TOCOL \ud568\uc218)<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\t\n\t\n\t\n
G3 cell =TOCOL($B$3:$E$5,<\/mark>1<\/mark>,<\/mark>1<\/mark>)<\/mark><\/strong><\/p>\n\n\n\n<\/figure>\n\n\n\n<\/p>\n\n\n\n<\/span>\uacb0\ub860<\/strong><\/span><\/h2>\n\n\n\n\uc5d1\uc140 \ub370\uc774\ud130\uc758 \ubcc0\ud658\uc740 \uc0b0\ucd9c\ud558\uace0\uc790 \ud558\ub294 \uac12\uc744 \uad6c\ud558\ub294 \uccab\ubc88\uc9f8 \ub2e8\uacc4\uc785\ub2c8\ub2e4. \uc5d1\uc140 \ub370\uc774\ud130 \uc815\ub82c\uc740 \ub9ce\uc740 \ubc29\ubc95\ub4e4\uc774 \uc788\uc9c0\ub9cc \ub370\uc774\ud130\uc758 \uc591\uc5d0 \ub530\ub77c \uc0c1\ud669\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"\uc5d1\uc140 TOCOL \ud568\uc218 – \ud14c\uc774\ube14\ub85c \uc774\ub8e8\uc5b4\uc9c4 \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\uae30 \uc704\ud574 \ub300\ud45c\uc801\uc778 \uc5d1\uc140\uc758 \ubcf5\uc0ac \ubd99\uc5ec\ub123\uae30 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud560 \uac81\ub2c8\ub2e4. \ud558\uc9c0\ub9cc TOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uc190\uc27d\uac8c \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c \uc904\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. …<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[506,507,500,511,501,502,505,510,504,503,508,509],"jetpack_publicize_connections":[],"yoast_head":"\n\uc5d1\uc140 \ub370\uc774\ud130 \ud55c\uc5f4\ub85c, \ud55c\uc904\ub85c \uc815\ub82c\ud558\ub294 \ubc29\ubc95(TOCOL \ud568\uc218)<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\t\n\t\n\t\n
\uc5d1\uc140 \ub370\uc774\ud130\uc758 \ubcc0\ud658\uc740 \uc0b0\ucd9c\ud558\uace0\uc790 \ud558\ub294 \uac12\uc744 \uad6c\ud558\ub294 \uccab\ubc88\uc9f8 \ub2e8\uacc4\uc785\ub2c8\ub2e4. \uc5d1\uc140 \ub370\uc774\ud130 \uc815\ub82c\uc740 \ub9ce\uc740 \ubc29\ubc95\ub4e4\uc774 \uc788\uc9c0\ub9cc \ub370\uc774\ud130\uc758 \uc591\uc5d0 \ub530\ub77c \uc0c1\ud669\uc5d0 \ub9de\ub294 \ubc29\ubc95\uc744 \uc120\ud0dd\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"
\uc5d1\uc140 TOCOL \ud568\uc218 – \ud14c\uc774\ube14\ub85c \uc774\ub8e8\uc5b4\uc9c4 \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c\uc5f4\ub85c \uc815\ub82c\ud558\uae30 \uc704\ud574 \ub300\ud45c\uc801\uc778 \uc5d1\uc140\uc758 \ubcf5\uc0ac \ubd99\uc5ec\ub123\uae30 \ub2e8\ucd95\ud0a4\ub97c \uc0ac\uc6a9\ud560 \uac81\ub2c8\ub2e4. \ud558\uc9c0\ub9cc TOCOL \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uba74 \uc190\uc27d\uac8c \uc5d1\uc140 \ub370\uc774\ud130\ub97c \ud55c \uc904\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. …<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[3],"tags":[506,507,500,511,501,502,505,510,504,503,508,509],"jetpack_publicize_connections":[],"yoast_head":"\n