•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula needed to auto categorize budget
I want my budget to automatically categorize my transactions. I have a tab made up of all the different transactions that go through my bank account and next to each is the applicable category. I need a formula that will search the transaction list and enter the applicable categories.
This is my BUDGET tab. O is the column I would like to enter a formula in to automatically enter the category based on the information in N
This is my LIST tab, within the same spreadsheet
Thank you in advance!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#formula generator
#cloud-based spreadsheet applications
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#Excel alternatives for data analysis
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#Excel alternatives
#spreadsheet API integration
#budget
#transactions
#categorize