Forum Discussion
Sorting & Counting with multiple criteria
I have the following columns. The data I want to count are in PRI INS ID and CLAIM ID. Each column has duplicates in them. How do I get Excel to count the number of claims per insurance ID? For e...
Monica, do you consider PivotTable as an option? Perhaps that will be the easiest way - create PivotTable on your range, creating it check Add data to data model, select Distinct Count in field settings for Claim ID.
Please check attached.