Solved

Excel - group same entries...

Posted on 2006-06-11
4
719 Views
Last Modified: 2012-06-27
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

0
Comment
Question by:stevem5000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 81

Accepted Solution

by:
byundt earned 250 total points
ID: 16882510
Hi stevem5000,
It's called a PivotTable.

Creating a PivotTable can be somewhat challenging because of the unfamiliar nature of the wizard. To create a PivotTable:
1) Make sure that each column has a heading label, then select any point within your data
2) Open the Data...PivotTable and PivotChart Report menu item
3) Click Finish in the resulting wizard. This will create a PivotTable on a new worksheet. Or you can click "Next" twice and choose to put the PivotTable in the existing worksheet in step 3 of the wizard. You'll then need to pick the top left cell of that report.

The tricky part come next. You will be presented with a blank PivotTable with big labels for the type of data required in each section. You need to drag named fields from the "PivotTable field list" dialog onto the PivotTable.
4) Drag the "Name" field label into the "Drag Row Items Here" field
5) Drag the "Amount" field label into the "Drag Data Items Here" field

You now have a PivotTable showing the sum of the amounts owed by each different person in the row fields.

Hoping to be helpful,

Brad
0
 
LVL 2

Author Comment

by:stevem5000
ID: 16882519
Wow...that was QUICK...!!!!

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

Steve
0
 
LVL 2

Author Comment

by:stevem5000
ID: 16891351
Perfect...

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

thanx

Steve
0
 
LVL 81

Expert Comment

by:byundt
ID: 16891386
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
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question