tom_blamire
Board Regular
- Joined
- Dec 13, 2012
- Messages
- 99
Hi,
I have a pivot table that uses the OFFSET function to drag in my data dynamically as kindly shown by Bill "Mr Excel" Jelen. The issue that i am having now is that im having now is that when i go to filter my data i get a alue of "0" that can be filtered on.
If i look in my data, there is not a "0" any where to be seen in the corresponding column.
Someone please help me solve this!!!
Kind regards
Tom
I have a pivot table that uses the OFFSET function to drag in my data dynamically as kindly shown by Bill "Mr Excel" Jelen. The issue that i am having now is that im having now is that when i go to filter my data i get a alue of "0" that can be filtered on.
If i look in my data, there is not a "0" any where to be seen in the corresponding column.
Someone please help me solve this!!!
Kind regards
Tom