I have a list of 1000 customers including their customer name, customer number and order total in rows. I have several customers listed more than once throughout the entire document. I need to combine the order totals into one sum (in dollars) for each customer (instead of having 1 customer listed 3 times and counted as 3 customers with 3 different sums). Is there a way to highlight all of the data and then merge rows with the same customers into one account without have to go through the document customer by customer?
It's a little confusing, so maybe I'm not making sense . . .
Thanks in advance for any help you can offer
Ex.
Customer # Name $
234 Joe $10
234 Joe $10
346 Jill $15
I need the easiest way to merge "Joe's" two totals - and I have to do it on 1000+ customers.
Thanks!
Bookmarks