•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Categorise using partial key word
Hello I am doing expenses tracking and I want to use a formula to pull certain keyword from my expenses line for categorisation.
Eg:
Jack’s grocer store $xxx —> formula to pull the partial key word from keyword listing
Car petrol $xxx —> formula to pull the partial key word from keyword listing
Keyword list:
“Grocer” —> Groceries
“Car” —> transport
[link] [comments]
Want to read more?
Check out the full article on the original site