Εμφάνιση 2 στηλών σε μία
 

Εργασία:
Δημιουργία λίστας τιμών των στηλών A;B (στις οποίες μεσολαβούν κενά)
στη στήλη C χωρίς κενά.

<table style="BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="WIDTH: 30px"> <col style="WIDTH: 69px"> <col style="WIDTH: 79px"> <col style="WIDTH: 69px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt"> <td>
</td> <td>A</td> <td>B</td> <td>C</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Θανάσης</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Ελένη</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Θανάσης</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Γιάννης</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Τάσος</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Γιάννης</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Μαρίνος</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Χρήστος</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Μαρίνος</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Δημήτρης</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> Δημήτρης </td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Ελένη</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid"> Λίτσα </td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Τάσος</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Χρήστος</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">Λίτσα</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td> <td style="BORDER-BOTTOM: #000000 1px solid; BORDER-RIGHT: #000000 1px solid">
</td></tr></tbody></table>
<table style="BORDER-BOTTOM-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-LEFT-STYLE: groove; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-STYLE: groove; FONT-SIZE: 10pt"> <tbody> <tr> <td>Τύποι</td></tr> <tr> <td> <table style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"> <td>Κελί</td> <td>Τύπος</td></tr> <tr> <td>C1</td> <td>{=IF(ROW(A1)>COUNTA(A:B);"";IF(ROW(A1)>COUNTA(A:A);INDEX(B:B;SMALL(IF(B$1:B$999<>"";ROW($1:$999));ROW(A1)-COUNTA(A:A)));INDEX(A:A;SMALL(IF(A$1:A$999<>"";ROW($1:$999));ROW(A1)))))}</td></tr></tbody></table></td></tr> <tr> <td>Τύπος πίνακα:
Δημιουργεί { } όταν κλείσετε
τον τύπο με CTRL+SHIFT+ENTER.</td></tr></tbody></table>