In this video, I show how to categorize data in Excel based on a list of keywords and how to categorize expenses in Excel.
I have a list of keywords commonly used in bank descriptions. If the bank description contains a certain keyword, I want to categorize the vendor and expense categories.
The functions featured in this video tutorial are SEARCH and LOOKUP.
Useful Article: exceljet.net/f...
Негізгі бет Categorize data in Excel | Easily categorize bank transactions using Excel
No video
Пікірлер: 18