Link to home
Start Free TrialLog in
Avatar of Steve Mutchler
Steve MutchlerFlag for United States of America

asked on

Excel - group same entries...

Excel 2003

Here is a simple example of what I want to do...

In my spreadsheet I have about 100 entries...
Let's assume that some people owe me money...Tom Dick and Harry...John and Mary...etc...

Tom has 6 entries in my spread sheet
Dick has 4 entries
Harry has 11 entries
etc etc etc

I think there is an automatic function that will group all of Tom's entries and subtotal how much he owes me...
Same for the rest of the folks...

I could sort on "Names" and create a subtotal for my multiple entries...but I think I remember an "automatic" function to do this...

Or am I wrong???

Thanx

ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Steve Mutchler

ASKER

Wow...that was QUICK...!!!!

Let me work with this...make sure it does what I want...

Steve
Perfect...

Took me a while to figgure it out...but exactly what I needed...

thanx

Steve
Steve,
I'm glad to hear you liked the PivotTable approach. It's a powerful tool in the right applications.

Thanks for the grade!
Brad