•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