combine row and the delete duplicates
 

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

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.)

bamamike wrote:

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

--

Dave Peterson

you can use Sumif function:
A B C
D
Customer 2000 Sales 2001 Sales
Joe Smith =sumif(A1:A4,"Joe Smith",B1:B4) =sumif(A1:A4,"Joe
Smith",c1:c4)
or
=sumif(A1:A4,$A$1,B1:B4) =sumif(A1:A4,$A$1,c1:c4)

"bamamike" wrote:

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