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...
Hi Monica_Shook,
Please see the attached file with your requested result, to quickly solve your query you need the new Excel Dynamic Arrays feature. Which is only available for Office365 & Excel Online
One thing to note that there are not 17 records against the PRI INS ID is 36066, there are 20 records out of which 10 Unique.
If something is not working as you mention, please attached file with your desired output manually entered.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more