Alternative to pivot table ?
For what it's worth, my considerations:
- As per Don, you can use Sumproduct. You'd need to write slightly
more sophisticated formulas than usual and you might get a performance
hit. But in this case it's all real time once the formula has been
written.
- You could still use the benefits of pivot table by using the
GetPivotDate formula. You still need to have a pivot somewhere (hidden
sheet or something) that needs to be refreshed but you'll have your
own formatting as desired. The formula is more user friendly than
Sumproduct.
- You can do it via VBA but then you'll need to run it on regular
basis anyway.
On Mar 14, 1:47*pm, darkblue wrote:
On Mar 14, 3:39*pm, AB wrote:
What makes Pivot to not be the obvious choice? What don't you like
about it?
Borders, for one
Coloring and formatting, for two
Having to use supporting functions like:
Refreshing, deleting missing items, sorting, disabling/enabling etc.
Rgds
|