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

C

crogers99999

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?
 
B

Biff

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
 

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

How to implement two shifts per day with multiple teams 0
Counting instances of Specific column entry combinations 1
Calculate the median value before a specified list 0
Possible to Combine reports to's to a single box? 0
Arriving at totals 2
Function in Excel to count and list number of entries of text valuesin a row. 2
Search and Combine Rows 4
Multiple IF Statement in Word 5

Top