Hide Duplicate Rows

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

Guest

Hi,
I have a spreadsheet with names that repeat in one column and different
numbers in other columns. I would like to group the names so that it only
shows one instance of each name and also performs a total for each row that
contains that name. For example John & Mary may occur 10 times with 10
different payments each, however, I want to only list both John & Mary once
and give me a total of their payments.

Is this possible and if so how can I do it. Thanks very much.
 
Ty,

Try converting your data to a Pivot Table. You could also write code to
accomplish this.
 
Try Advanced Filter to filter all the unique records, then use SUMIF function
to sum all the unique names.
 
You could also select a cell to output to and then choose Data >
Consolidate with reference as your table range and row and column
headings and sum all selected.
 

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

find all instances of a search item and put result in a single cel 5
Conditional Formatting with Partial name search 2
Multi NetWorkDays Calculation 3
Need suggestions on layout to report/pivot 3
Should I use COUNT IF? from one sheet to another 2
How to remove duplicated data repeated.... 7
Min Match Function needed 8
COUNTIF in between rows 10

Back
Top