Excel Pivot Table newbie question

Go-Bruins used Ask the Experts™
Hello all,

I have a simple Excel sheet that looks like this:

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.
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.
Group Finance Manager
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


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