•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to find and count values per document number in separate tables
Dear Excel experts,
I am trying to build a summary of all exceptions in certain documents using excel formulas. I've tried INDEX & MATCH but could not make it work.
Here's an example of what I am trying to achieve:
in the table to the left, I count the number of times a certain exception has occured for a specific document, where the data is stored on the right (on another sheet)
For example, document #25 has 2 policy deviations but no pricing deviation, while document #26 has one deviation of each type.
How would you approach this and which formulas would you recommend using in the table to the left?
[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
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel
#formulas
#INDEX
#MATCH
#exceptions