•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to have sheet2 data in sheet1 table not move when using sort column function
So I have order data in sheet 2 that needs to total up into corresponding data in sheet 1.
Every order in sheet 2 gets an account #, and that acc# corresponds to a specific row on Sheet 1, but the actual total calculation goes into a different column of that same row.
Currently, i can get the function to work so long as i dont use the sort header tool which is not ideal since sometimes i need to sort by volume high/low, account name a-b, and so forth.
How do i make it so the sum tracker for each account stays in the corresponding row no matter which row the account ends up in?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#row zero
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#rows.com
#natural language processing for spreadsheets
#Excel compatibility
#sheet1
#sheet2
#account number
#order data
#total calculation
#corresponding row
#Excel
#sum tracker
#sort column
#function