How to remove duplicated ID but have them add up the values the ID represneted

Originally Posted by jindon

VBA solution, if you like

I have no idea how you created that.

I'm only looking for one value per owner from the EDU. If the EDU is repated then it is only added onece such as


OWNER___________________________EDU
A T AND T COMMS OF CALIF INC____00000.5855 <----It is repeated several times
A T AND T COMMS OF CALIF INC____00000.5855
A T AND T COMMS OF CALIF INC____00000.5855
A T AND T COMMS OF CALIF INC____00000.5855
A T AND T COMMS OF CALIF INC____00004.5270 <-----This one is different

So the Result for the EDU and the Owner is 00000.5855 + 00004.5270 = 00005.1125



OWNER ______________________EDU
A T AND T COMMS OF CALIF INC____00005.1125 <---What the end result should look like