Pivot table error

T

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
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sort by date Sort by votes
please provid a link to the post with the OFFSET
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
Two dimensional dynamic named range over a pivot table not working as I thought
Replies
4
Views
301
ashleighbrown
A
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
1K
Alex Blakenburg
A
L
  • Question
Filter date range to last 365 days (Pivot Table)
Replies
2
Views
429
LeonardH
L
F
  • Solved
Problems filtering a Pivot Table with VBA
Replies
2
Views
194
Domenic
D
M
  • Question
Pivot Table Help
Replies
1
Views
100
shift-del
shift-del

Forum statistics

Threads
1,214,989
Messages
6,122,622
Members
449,093
Latest member
catterz66

Share this page

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