yellowcabguy
Active Member
- Joined
- Dec 28, 2005
- Messages
- 440
I am experiencing a problem in grouping dates in my pivot chart and am wondering if it has somethign to do with the defined name range I created to aid in refreshing the table when I add more data. Is it possible that the "65536" in the formula is causing the problem??
=OFFSET(Inventory!$A$3,0,0,COUNTA(Inventory!$A$3:$A$65536),90)
=OFFSET(Inventory!$A$3,0,0,COUNTA(Inventory!$A$3:$A$65536),90)