Excel Pivot Table newbie question

Go-Bruins
Go-Bruins used Ask the Experts™
on
Hello all,

I have a simple Excel sheet that looks like this:

Table
I'd like some kind of pivot table (or the like), that auto counts the number of movies for the Actor, and also sums up the budget. Something like this:

Pivot Table
Thanks in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Attached please find an example file with macro.

Click on the macro button and it will give you the required output.
Pivot-2.xlsb
Group Finance Manager
Commented:
The example bears no relation to the images. Looking at the images then you would need to separate the actor's name to a separate column.

If you have a column of names then you can use a PivotTable
Pivot-2.xlsb

Author

Commented:
Both answers have given me valuable insight. Thank you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial