In Microsoft Excel, how do i get rid of duplicate items while adding their respective values?

In Microsoft Excel, how do i get rid of duplicate items while adding their respective values

In Microsoft Excel, how do i get rid of duplicate items while adding their respective values?virus protection software

If you are asking to display each value once, and have a total for each value, then I would use subtotals (use the wizard from the menu: Data / Subtotals)

Hope this helps