•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Daily account balance variance analysis
I have a list of several thousand names, relationship ID number (formatted as text), and account balance. The relationship ID is unique but names are not.
I need to identify day over day which account balances change (either increase or decrease) by $1,000. This is reviewed every day, and the list changes each day as new accounts are added and/or closed.
Editing to add that I am using excel 365
Can this be done without power query?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#generative AI for data analysis
#conversational data analysis
#data analysis tools
#account balance
#variance analysis
#Excel 365
#relationship ID
#day over day
#daily review
#power query
#change detection
#increase
#decrease
#data analysis
#financial tracking
#account management