I have SKUs (part number) in one column that and sales in another column I need to sum the sales and remove the duplicate SKUs once all the sales figures are totaled.
Column P is the Item numbers
Column V is the sales
need to sum the sales based on the part numbers
View best response
The easiest way to do that is to create a Pivot Table.
Assuming the Part number is in column A and the Sales in Column B:
and you are done
You need to apply some formatting specially to the numbers.
Hope that Helps
even if I have thousands of part numbers?
even with hundreds of thousands
If you share sample data I do it for you in 2 minutes