How to find and remove duplicate rows in excel?

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

Guest

I want to know a way that you can group together duplicate rows and remove
them so each row in the worksheet is unique.

Thats not so hard but I also want when removing the row that columns value
next to it be summed up i.e.

Column A | Column B

Y 5
X 10
Y 10
Z 2

would become: -

Column A | Column B

Y 15
X 10
Z 2

Any help you can give would be greatly appreciated,

Thanks
 
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

Lookup in a matrix (with x and y headings) based on value x and y 2
Summing cells based on mulitiple criteria over mulitple columns 1
Scrabble Value calculation for Welsh words 0
How to remove row duplicates 1
Summary count from different worksheets? 4
transpose rows to column (cell) 3
Sort, select and average macro help 2
Multiple worksheets? 3

Back
Top