combine row and the delete duplicates

B

bamamike

combine duplicates clmns then delete duplicate
Customer 2000sales 2001 Sales 2002 sales

Joe Smith $200.00
Joe Smith $300.00
Joe Smith $250.00
Kip Tucker $100.00
Kip Tucker $175.00
Kip Tucker $225.00

I need to combine these on to one row but leave them under the
appropriate year and then delete the duplicate names My post doesn't
show it but the values should be under each year
I want the results too look like this


Customer 2000sales 2001 Sales 2002 sales

Joe Smith $200.00 $300.00 $250.00
Kip Tucker $100.00 $175.00 $225.00
 
D

Dave Peterson

How about just selecting your range and doing:

Insert a new worksheet
and then back to your data worksheet
Data|subtotals
At each change in Customer
use Sum as the function for each of the yearly columns.

Then you'll have the subtotals for each person.
Use the outlining symbols to the left to hide the details.
Select your range
edit|goto|special|visible cells only
edit|copy
Edit|Paste special|values
on that new worksheet.

Select column A of that new worksheet and
edit|replace
what: _Total (_ represents a space bar)
with: (leave blank)
replace all.

(Delete that grand total line if you copied it and don't want it.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top