Remove duplicate but add values.xlsx
Hi,
I have about 800 records and the the unique identifier are the names. Some owners are repeated several times and they have different values for the EDU column in my project. I need to remove any duplicated owners but I need to add up the values of each record that had value so I can get a combined value for one owner instead of a repeated owner with smaller values. How would I go by doing that? A formula or is there a tool in excel? I am lost on this one. I uploaded a sample file so you can see what I trying to do. Thanks.
BTW i found if the values are the same for the EDU then I can not add them since it is also duplicated. I can only add up the unique values for the EDU
Bookmarks