98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to categorise transactions and rename them | Excel forum
How to categorise transactions and rename them | Excel forum
Resolved · High Priority · Version 2016
Wed 23 May 2018, 12:47Delegate Sophie said...
Sophie has attended:
Excel Intermediate course
Excel Advanced course
How to categorise transactions and rename them
Hi,
I have a big list of data of transactions from a credit card, and I would like to create a formula to categorise these automatically.
I have created a separate tab that lists each transaction name and what the category should be. So for example, Tesco/Sainbury's transactions should be the 'Groceries' category, Uber transactions should be 'travel' categories etc.
I have played around with Lookups and If functions but cannot work out how to do it.
I can send you the raw data spreadsheet if that would be helpful
Please can you advise how to process?
Many thanks
Sophie
Thu 24 May 2018, 22:01Trainer Wendy said...
RE: How to categorise transactions and rename them
Hi Sophie
Thank you for using our forum
Both Vlookups and IF statements would be able to do this but you would need to use absolute references to lock the area that it would be looking from.
Could you please send the file to info@stl-training.co.uk
Kind regards
Wendy Canelas
Microsoft Office Trainer
Tue 29 May 2018, 10:59Trainer Wendy said...
RE: How to categorise transactions and rename them
Hi Sophie
The tab Key is going to give a problem. Your search criteria needs to have a specific criteria. At the moment you have too much criteria in a single cell for the formulas to read.
It might be simpler to add a data validation field into the column next to it and select the category from a drop down field
Kind regards
Wendy Canelas
Microsoft Office Trainer
Tue 5 Jun 2018: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing Multiple Workbooks quicklyWhen you have several workbooks open in Excel and want to just close them all at once: |
