How to categorise transactions and rename them | Excel forum

Resolved · High Priority · Version 2016

Wed 23 May 2018, 12:47 Delegate 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:01 Trainer 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:59 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips