•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
Tagged with
#AI formula generation techniques
#formula generator
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#Grocer
#Car
#expenses
#keyword
#partial keyword
#tracking
#categorisation
#Groceries
#formula
#transport
#keyword listing
#expenses line