How do I combine totals for multiple rows that have a like value .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that has over 400 people on it with some appearing 2 to
3 times. I would like to find a way to consolidate each person into just one
row per person and sum up their total for one of the fields. Is this
possible?
 
Hi!

One way is to use an advanced filter and copy the unique
values to another location. Would need more detailed info
for a more specific suggestion.

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

consolidate multiple worksheets 13
How do I count instances of a reference? 1
Search and Combine Rows 4
Scrabble Value calculation for Welsh words 0
Adding up total hours worked on employee schedule using various criteria 0
pivot table - get the average of a field 1
Pivot Tables - get a total different than the summarize field sett 1
Excel Help to copy information from one row at a time to another sheet 1

Back
Top