merge same valu and total the amount indicated

  • Thread starter Thread starter geon12x
  • Start date Start date
G

geon12x

I have thousands of invoice most of them have the same invoice number. every
invc# contains crdt type and some of them are the same too but each of them
have the amount.

How to sort them to show no redunduncy of invoice and crdt type and the
amount will show only the total of each crdt type?
 
You should be able to do this by sorting by invoice number, then
Data->Subtotal and select at each change in invoice number, sum what you want
summed.
 

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

Similar Threads

template creates invoice - how to create summary worksheet? 13
Total then Sort 2
vlookup question 2
Locating row with no duplicate matching amount 1
sum column D based on column A 1
Pivot table formatting - colors 3
Divide One Amount for Duplicates 1
Excel to Mail Merge 3

Back
Top