Pivot Table - Using a Dynamic Range

[BlueRhinos]

Because my pivot table is used by several users the data source changes often. In response, I created and applied a dynamic range using the offset formula. While the pivot talbe grabs the correct # of records, it inserts a blank column and row. There are NOT any blank cells in the data source range, as reflected by pivot table counts for the Blank column and Row. Any idea why Blank is showing up in my pivot table and how I can correct while maintaining the dynamic range?

Thanks!

BlueRhinos

 

[BlueRhinos]

Glenn,
This worked...your advice via blogging is better than any excel training out there! Thanks again...can you explain the "=?*" syntax to me?

Bluerhinos

 

[GlennUK]

Hi DB,

thanks for the compliments.

The "-?*" syntax is using wildcard expressions. Basically you can use "?" for any single character, and "*" for any bunch of characters, so the syntax I used searches for anything that is longer than ( or equal to ) one character in length ( results of formulae, not the formulae themselves ).