Steve Mutchler
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect...
Took me a while to figgure it out...but exactly what I needed...
thanx
Steve
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
I'm glad to hear you liked the PivotTable approach. It's a powerful tool in the right applications.
Thanks for the grade!
Brad
ASKER
Let me work with this...make sure it does what I want...
Steve