•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Identify Missed Amounts From PivotTable to Payment Table
I am unable to share the original file which shows the data source. I hope you can help me based on what you see within the worksheet though.
In the spreadsheet, the Payment Table, Amount column is referencing the PivotTable based on the Function and the AOBJ within the PivotTable. The value from the PivotTable is then showing in the Amount column.
I am open to suggestions, but I am needing a way to identify the lines that are showing on the PivotTable but are not showing on the Payment Table so that I can add those lines.
https://docs.google.com/spreadsheets/d/1OXc43YGwYe0sHSCyUPgDGfaJqiEHMp-c8ofifkyg9TM/edit?usp=sharing
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#cloud-based spreadsheet applications
#big data management in spreadsheets
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#AI-native spreadsheets
#google sheets
#financial modeling with spreadsheets
#predictive analytics in spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#conversational data analysis
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#real-time data collaboration
#automation in spreadsheet workflows