•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Translating a Bank Statement to a Journal Entry
I need to translate a bank statement in a spreadsheet to a format suitable for uploading to my accounting system.
-The banks' descriptions are in different formats with important info in different spots.
-The journal entry descriptions can only hold about half the characters that the statement's descriptions can.
-I also need it to reference the relevant journal accounts.
"CDS0000589" needs to be "check 589" to account 110
"BANK STTLEMENT FEE 260319 58363" needs to be "bnk fee 0319" to account 650
Is there some kind of formula for "check cell x for a chunk of data that matches table y and apply the formula in that row"?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#AI formula generation techniques
#rows.com
#big data management in spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#conversational data analysis
#Excel compatibility
#row zero
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#real-time data collaboration
#financial modeling with spreadsheets
#automation in spreadsheet workflows
#intelligent data visualization