Hi
I would suggest a pivot table.
<table valign="middle" colspan="4" style="font-family: Calibri; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11px; font-weight: normal; font-style: normal;" border="1" cellpadding="2" cellspacing="0"><colgroup><col width="28pt"><col width="40,5pt"><col width="45,75pt"><col width="99pt"></colgroup><tbody><tr style="background-color: rgb(250, 250, 250);"><td colspan="4" align="middle">Arbeitsblatt mit dem Namen 'Tabelle1'</td></tr><tr style="background-color: rgb(202, 202, 202);"><td>
</td><td align="middle">A</td><td align="middle">B</td><td align="middle">C</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">1</td><td align="left">Grade</td><td align="left"># of days</td><td align="left">overdue</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">2</td><td align="left">Grade 1</td><td align="right">15</td><td align="left">1 week - 1 month</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">3</td><td align="left">Grade 1</td><td align="right">15</td><td align="left">1 week - 1 month</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">4</td><td align="left">Grade 2</td><td align="right">65</td><td align="left">more than 2 months</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">5</td><td align="left">Grade 2</td><td align="right">57</td><td align="left">1 month - 2 months</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">6</td><td align="left">Grade 2</td><td align="right">5</td><td align="left">less than 1 week</td></tr></tbody></table>
<table valign="middle" colspan="2" style="table-layout: auto; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; font-size: 10px;" border="3" cellpadding="2" cellspacing="0"><colgroup><col width="40pt"><col></colgroup><tbody><tr style="background-color: rgb(238, 170, 170);"><td>Zelle</td><td>Formel</td></tr><tr><td>C2</td><td>=IF(D2,"less than 1 week",IF(E2,"1 week - 1 month",IF(F2,"1 month - 2 months","more than 2 months")))</td></tr></tbody></table><table style="font-family: Arial; font-size: 7pt;"><tbody><tr><td style="color: rgb(51, 51, 51);">Diese Tabelle wurde mit Tab2Html (v2.4.1) erstellt. ©Gerd alias Bamberg</td></tr></tbody></table>
<table valign="middle" colspan="6" style="font-family: Calibri; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11px; font-weight: normal; font-style: normal;" border="1" cellpadding="2" cellspacing="0"><colgroup><col width="28pt"><col width="99pt"><col width="81,75pt"><col width="85,5pt"><col width="95,25pt"><col width="99pt"></colgroup><tbody><tr style="background-color: rgb(250, 250, 250);"><td colspan="6" align="middle">Arbeitsblatt mit dem Namen 'Tabelle3'</td></tr><tr style="background-color: rgb(202, 202, 202);"><td>
</td><td align="middle">A</td><td align="middle">B</td><td align="middle">C</td><td align="middle">D</td><td align="middle">E</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">1</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">2</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">3</td><td align="left">Number of # of days</td><td align="left">overdue</td><td align="right">
</td><td align="right">
</td><td align="right">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">4</td><td align="left">Grade</td><td align="left">less than 1 week</td><td align="left">1 week - 1 month</td><td align="left">1 month - 2 months</td><td align="left">more than 2 months</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">5</td><td align="left">Grade 1</td><td align="right">
</td><td align="right">2</td><td align="right">
</td><td align="right">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">6</td><td align="left">Grade 2</td><td align="right">1</td><td align="right">
</td><td align="right">1</td><td align="right">1</td></tr></tbody></table><table style="font-family: Arial; font-size: 7pt;"><tbody><tr><td style="color: rgb(51, 51, 51);">Diese Tabelle wurde mit Tab2Html (v2.4.1) erstellt. ©Gerd alias Bamberg</td></tr></tbody></table>