How to find and remove duplicate rows in excel?

S

Stewbo

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
 
Top