ExcelBanter - pivotTable and filtered list

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - pivotTable and filtered list (https://www.excelbanter.com/excel-programming/280216-pivottable-filtered-list.html)

No Name

pivotTable and filtered list

Is it possible to create a PivotTable with a filterred
list ?

Tom Ogilvy

pivotTable and filtered list

If you meant the pivot table would only deal with the visible data, then the
answer is no.

You could filter the data and copy it it do a new location, then use that as
the source for the pivot table.

Can't you reproduce the filtering using the pivot table itself?

--
Regards,
Tom Ogilvy

wrote in message
...
Is it possible to create a PivotTable with a filterred
list ?

All times are GMT +1. The time now is 12:29 PM.