Merge Cells with Same Value and plus average

[elecgenius]

Hello,

I am trying to achieve the following by VBA:

This

A B C D
1 Name Quantity Cost Cost Per
2 Dog 1 150 150
3 Dog 2 300 150
4 Cat 1 150 150
5 Cat 1 150 150
6 Mouse 3 300 100

To this

A B C D
1 Name Quantity Cost Cost Per
2 Dog 3 450 150
3 Cat 2 300 150
4 Mouse 3 300 100

I am trying to merge the rows that have similar Data on Columns A,B,C and then give the average on D

I have them sorted by Column A already so the rows would be adjacent.

Column D contains a formula to find the average of C which makes it a little more complicated.

Any help would be greatly appreciated,

[karedog]

Maybe :

Please Login or Register  to view this content.

[elecgenius]

Excellent Karedog!

Worked like a charm. Thank you so much!

[karedog]

You are welcome. Thanks for marking the thread as solved and for the rep.point.


Regards