table row count

  1. S

    Push down rows when rows added to table ..... how?????

    I have a Table (Table1) in one of my sheets. Let's say it goes from A2:D45. From A50:D60, I have some additional cells (range) being used for other items. When I go to A46 and input something, the table increases by one row, now including the data input in A46. This is what I want it to do...
  2. M

    Formula to Derive Table Row Count

    Hey Everyone, I need a formula to place in a cell that will determine the number of data rows in an Excel table. I have been using ROWS(Table1) which works perfectly except for the fact that it returns 1 even when there is no data in the table. How else could I go about doing this? Thanks in...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top