ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table vs Filter (https://www.excelbanter.com/excel-discussion-misc-queries/100349-pivot-table-vs-filter.html)

[email protected]

Pivot Table vs Filter
 
What is the difference between a Pivot Table and a Filter. From an
"introductory" point of view, they seem to do basically the same thing.
When would I want to use one over the other?

Thanks.


Marcelo

Pivot Table vs Filter
 
Hi, Gold,

Pivot table is one of the most power tools of excel, take a look on the
Debra's page at

http://www.contextures.com/tiptech.html

to see more regarding pivot tables

hth
regards from Brazil


" escreveu:

What is the difference between a Pivot Table and a Filter. From an
"introductory" point of view, they seem to do basically the same thing.
When would I want to use one over the other?

Thanks.



Bill Ridgeway

Pivot Table vs Filter
 
I currently use Pivot tables but last used Filter several years ago.

Pivot table are useful where the analysis is straight forward. Filtering
allows inclusion / exclusion of any number of fields and by the value in the
field so it is more comprehensive. To my mind Filtering is easier to
construct and also easier to check and change parameters.

Regards.

Bill Ridgeway
Computer Solutions

wrote in message
oups.com...
What is the difference between a Pivot Table and a Filter. From an
"introductory" point of view, they seem to do basically the same thing.
When would I want to use one over the other?

Thanks.




[email protected]

Pivot Table vs Filter
 
This looks like a good site, thanks.



http://www.contextures.com/tiptech.html




All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com