Automatic parsing and summing up of items

Hi experts!

I have attached an example file that is quite simple. I would like to know how to do the following:

 Trace-and-sum-items.xlsx

1. Go (down) through column A line by line
2. If the "name" (e. g. "Item 1) has not been found before, Then it should be written into the first empty row of column E and the value should be added in row F ELSE only the value of Item 1 should be added to the corresponding entry in column F

1) I want to use this function to parse large lists that contain a lot of invoiced with customer names. Finally I want to have the invoice sum for each customer.
2) I would like to generate a simple bar graph from that, a simple coding example as a starting point would be ok for me to figure out the details, a simple bar graph would be ok
3) In addition I would like to add another column "date" so that finally I can get an overview of invoice sums per month per customer

I would be happy, if I could attach this function to a button in the ribbon so that any user could use it, provided the list has always the same columns (customer name, invoice sum...). It should be a "one click" process for a clearly defined input list.

Thank you very much in advance for helping me!




Mr_ThomasAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saqib Husain, SyedEngineerCommented:
The easiest way is a pivot table.

Insert a row at the top so that you can label the columns.
Label the columns A and B to something like "Item" and "Value"
Select columns A and B
Insert > Pivot table
Select Existing worksheet
Point to E1 and then click OK
From the pane on the right drag Item to Rows and drag Value to ¿ values
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.