table range

  1. A

    counting blank cells in every growing table

    I want to count the number of blank cells in A:A but only relating to my table size. Is there a way to only have the cells in my current table be counted? Formula's I've tried so far with no luck: =countblank(A:A) =countif(A:A,"") Also, I know it's not VBA code, but wanted to show it nicely...
  2. mrMadCat

    Table from other file as a source for pivot table

    Hi people! I have data in separate file organized as excel table range. I want to use this table name as a source for pivot table in other file. The funny thing it doesn't let me do this saying the range is wrong. Though it works ok inside 1 file. Additionally, trying to come around, when I...
  3. C

    Output Data based on 2 Data Validation Selections and Table Range

    Hello, I am creating a product selection tool for customers. In this selection tool they will be able to select options from different Data Validation lists. I want one option in the table to change based on 2 specific parameters that they have chosen and ultimately choose the right value from...
  4. H

    How do I set a table's range to automatically adjust to source data?

    I cant figure out how or if it is even possible to have a table automatically adjust its range or the number or rows it has based on another table I have two tables: Table1 is raw data that is added two daily Table2 has formulas with column header references to Table1 that processes the...
  5. H

    Specify range based on cell contents?

    I'm trying to create a macro that copies and sorts a table in 2 different places. I recorded a macro that did the trick at first but have come to the realization that since the ranges i recorded are static, than when i move the tables up or down one row they stop working. I therefore created 5...

This Week's Hot Topics

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
Top