sort my montly bank transactions in Excel: Please help!

Hi experts!
I am new to programming in Excel, but thought that it could be fairly easy to do the following (I wish I knew what to start with).
I have a bank statement with summary of transactions on my account, from various stores etc.
I would like to run an automatic search through the cells, based on some text strings, which will return automatic categories of each transaction.
Example:
If a cell contains a name of local grocery store, the next cell will return value "groceries". If another cell contains name of a gas station, the next cell will return "car expences".

I will then want to have a good overview of the breakdown of my monthly expenses.

Can anybody help me to start? what function will be the best approach?

Cheers Dennis

Thanks for a prompt reply.

Obviously, every line can contain different names, depending on a store. My thought was that if I "assign" various references to e.g. "Groceries" category, meaning that hitting certain words will return this value to the line, I can then re-use those next month, when Excel will already "know" these stores and the process will be repetitive.
of course, any new stores will have to be added at a later stage, but at least most of them will be gathered under one category.

Just to give you one example. Here are three lines from my statement.

Line1: 26.08 Kiwi 473 Haglundvn. 2 Nesoddtangen 636,72 Groceries
Line2: 27.08 Hairdresser Salong Lysaker Lysaker Torg Lysaker 620,00 Personal
Line3: 25.08 3408 Rimi Kapellveien Nesoddtangen 266,54 Groceries

Kiwi and Rimi are local stores. Both will return "Groceries" if I define that searching for the names of these stores will return category "Groceries".

Hope this is clear.

Hi
I think the best approach to solve your problem would be to create a column with the categories and then use a pivot table.
Regards

Hi
I send a sample workbook with your example

see the file Sample_TD.xlsx

Regards

José,
I appreciate your feedback. I am familiar with the Pivot tables and was going to use those for gathering the overview.
However, the Category column is not filled initially, that is what I need the requested function for.
I want Excel to scan through all the Decription rows and suggest Category names automatically.

Thanks again
D