<font size="3"></font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"></font> <table width="471" style="width:353pt;border-collapse:collapse;" border="0" cellspacing="0" cellpadding="0"><colgroup><col width="71" style="width:53pt;" span="2"></colgroup><colgroup><col width="65" style="width:49pt;"></colgroup><colgroup><col width="24" style="width:18pt;" span="11"></colgroup><tbody><tr height="25" style="height:18.75pt;"><td width="71" height="25" class="xl65" style="border-width:.5pt 0px;border-style:solid none;width:53pt;height:18.75pt;background-color:rgb(231,230,230);"><font face="돋움" size="2">연번</font></td> <td width="71" class="xl65" style="border-width:.5pt 0px;border-style:solid none;width:53pt;background-color:rgb(231,230,230);"><font face="돋움" size="2">성명</font></td> <td width="65" class="xl68" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;width:49pt;background-color:rgb(231,230,230);"><font face="돋움" size="2">직위</font></td> <td width="24" class="xl69" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;width:18pt;background-color:rgb(231,230,230);"><font face="돋움" size="2">1</font></td> <td width="24" class="xl69" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;width:18pt;background-color:rgb(231,230,230);"><font face="돋움" size="2">2</font></td> <td width="24" class="xl69" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;width:18pt;background-color:rgb(231,230,230);"><font face="돋움" size="2">3</font></td> <td width="24" class="xl69" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;width:18pt;background-color:rgb(231,230,230);"><font face="돋움" size="2">4</font></td> <td width="24" class="xl69" style="background:rgb(231,230,230);border:.5pt solid rgb(191,191,191);width:18pt;color:rgb(0,112,192);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;">5</td> <td width="24" class="xl69" style="background:rgb(231,230,230);border:.5pt solid rgb(191,191,191);width:18pt;color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;">6</td> <td width="24" class="xl69" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;width:18pt;background-color:rgb(231,230,230);"><font face="돋움" size="2">7</font></td> <td width="24" class="xl69" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;width:18pt;background-color:rgb(231,230,230);"><font face="돋움" size="2">8</font></td> <td width="24" class="xl69" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;width:18pt;background-color:rgb(231,230,230);"><font face="돋움" size="2">9</font></td> <td width="24" class="xl69" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;width:18pt;background-color:rgb(231,230,230);"><font face="돋움" size="2">10</font></td> <td width="24" class="xl69" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;width:18pt;background-color:rgb(231,230,230);"><font face="돋움" size="2">11</font></td></tr><tr height="25" style="height:18.75pt;"><td height="25" class="xl66" style="border-width:0px 0px .5pt;border-style:none none solid;height:18.75pt;background-color:transparent;"><font face="돋움" size="2">1</font></td> <td class="xl67" style="border-width:0px 0px .5pt;border-style:none none solid;background-color:rgb(242,242,242);"><font face="돋움" size="2">김우리</font></td> <td class="xl70" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">시설장</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td></tr><tr height="25" style="height:18.75pt;"><td height="25" class="xl66" style="border-width:0px 0px .5pt;border-style:none none solid;height:18.75pt;background-color:transparent;"><font face="돋움" size="2">2</font></td> <td class="xl67" style="border-width:0px 0px .5pt;border-style:none none solid;background-color:rgb(242,242,242);"><font face="돋움" size="2">이우리</font></td> <td class="xl70" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">사회복지사</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td></tr><tr height="25" style="height:18.75pt;"><td height="25" class="xl66" style="border-width:0px 0px .5pt;border-style:none none solid;height:18.75pt;background-color:transparent;"><font face="돋움" size="2">3</font></td> <td class="xl67" style="border-width:0px 0px .5pt;border-style:none none solid;background-color:rgb(242,242,242);"><font face="돋움" size="2">박우리</font></td> <td class="xl70" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">간호사</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S1</font></td></tr><tr height="25" style="height:18.75pt;"><td height="25" class="xl66" style="border-width:0px 0px .5pt;border-style:none none solid;height:18.75pt;background-color:transparent;"><font face="돋움" size="2">4</font></td> <td class="xl67" style="border-width:0px 0px .5pt;border-style:none none solid;background-color:rgb(242,242,242);"><font face="돋움" size="2">최우리</font></td> <td class="xl70" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">조리원</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S3</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S3</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S3</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S3</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S3</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S3</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S3</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S3</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">S3</font></td></tr><tr height="25" style="height:18.75pt;"><td height="25" class="xl66" style="border-width:0px 0px .5pt;border-style:none none solid;height:18.75pt;background-color:transparent;"><font face="돋움" size="2">5</font></td> <td class="xl67" style="border-width:0px 0px .5pt;border-style:none none solid;background-color:rgb(242,242,242);"><font face="돋움" size="2">김요리</font></td> <td class="xl70" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">요양보호사</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">N1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">N1</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">N1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">N1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">N1</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">N1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">N1</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td></tr><tr height="25" style="height:18.75pt;"><td height="25" class="xl66" style="border-width:0px 0px .5pt;border-style:none none solid;height:18.75pt;background-color:transparent;"><font face="돋움" size="2">6</font></td> <td class="xl67" style="border-width:0px 0px .5pt;border-style:none none solid;background-color:rgb(242,242,242);"><font face="돋움" size="2">이요리</font></td> <td class="xl70" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">요양보호사</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D2</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;"><font size="2">D2</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D2</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D2</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D2</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D2</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D2</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D2</font></td></tr><tr height="25" style="height:18.75pt;"><td height="25" class="xl66" style="border-width:0px 0px .5pt;border-style:none none solid;height:18.75pt;background-color:transparent;"><font face="돋움" size="2">7</font></td> <td class="xl67" style="border-width:0px 0px .5pt;border-style:none none solid;background-color:rgb(242,242,242);"><font face="돋움" size="2">박요리</font></td> <td class="xl70" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">요양보호사</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D1</font></td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border:.5pt solid rgb(191,191,191);color:rgb(255,0,0);font-family:'돋움';font-size:8pt;font-weight:400;text-decoration:none;background-color:transparent;">off</td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D1</font></td> <td class="xl71" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;background-color:transparent;"><font face="돋움" size="2">D1</font></td></tr></tbody></table><div><br>이런 식으로 된 근무표가 있는데요.</div> <div>다른 시트에, A1 셀에 1, A2 셀에 직위를 입력하면,</div> <div>A3 셀에 직원의 이름들이 뜨도록 하고 싶습니다.</div> <div> </div> <div>예를들어 A1과 A2에 각각 1, 요양보호사를 입력하면</div> <div>A3에 김요리, 이요리 이런식으로 뜨고</div> <div> </div> <div>A1과 A2에 3, 사회복지사를 입력하면</div> <div>A3에 아무것도 안뜨게 하고 싶거든요.</div> <div> </div> <div> </div> <div>이 경우 어떤 함수를 써야할까요?</div> <div> </div> <div> </div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.