Use an expand range (Note the $ signs in the formulas):
Sheet1
<table style="background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt; font-family: Calibri,Arial; font-size: 11pt;" border="1" cellpadding="0" cellspacing="0"><colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody><tr style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt; font-weight: bold;"><td>
</td><td>A</td><td>B</td></tr><tr style="height: 18px;"><td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">1</td><td>Title</td><td>Value</td></tr><tr style="height: 18px;"><td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">2</td><td>Check</td><td style="text-align: right;">1000</td></tr><tr style="height: 18px;"><td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">3</td><td>Deposit</td><td>
</td></tr><tr style="height: 18px;"><td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">4</td><td>Check</td><td style="text-align: right;">1001</td></tr><tr style="height: 18px;"><td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">5</td><td>Deposit</td><td>
</td></tr><tr style="height: 18px;"><td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">6</td><td>Deposit</td><td>
</td></tr><tr style="height: 18px;"><td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">7</td><td>Check</td><td style="text-align: right;">1002</td></tr><tr style="height: 18px;"><td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">8</td><td>check</td><td style="text-align: right;">1003</td></tr><tr style="height: 18px;"><td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">9</td><td>check</td><td style="text-align: right;">1004</td></tr><tr style="height: 18px;"><td style="text-align: center; background-color: rgb(202, 202, 202); font-size: 8pt;">10</td><td>deposit</td><td>
</td></tr></tbody></table>
<table style="border-style: groove; border-color: rgb(0, 255, 0); background-color: rgb(255, 252, 249); font-family: Arial; color: rgb(0, 0, 0); font-size: 10pt;"><tbody><tr><td>
Spreadsheet Formulas</td></tr><tr><td><table style="font-family: Arial; font-size: 9pt;" border="1" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>B3</td><td>=IF(UPPER
($A3="CHECK"),MAX
($B$2:$B2)+1,"")</td></tr><tr><td>B4</td><td>=IF(UPPER
($A4="CHECK"),MAX
($B$2:$B3)+1,"")</td></tr><tr><td>B5</td><td>=IF(UPPER
($A5="CHECK"),MAX
($B$2:$B4)+1,"")</td></tr><tr><td>B6</td><td>=IF(UPPER
($A6="CHECK"),MAX
($B$2:$B5)+1,"")</td></tr><tr><td>B7</td><td>=IF(UPPER
($A7="CHECK"),MAX
($B$2:$B6)+1,"")</td></tr><tr><td>B8</td><td>=IF(UPPER
($A8="CHECK"),MAX
($B$2:$B7)+1,"")</td></tr><tr><td>B9</td><td>=IF(UPPER
($A9="CHECK"),MAX
($B$2:$B8)+1,"")</td></tr><tr><td>B10</td><td>=IF(UPPER
($A10="CHECK"),MAX
($B$2:$B9)+1,"")</td></tr></tbody></table></td></tr></tbody></table>
Excel tables to the web - Excel Jeanie Html 4