Count Unique Values and Sum Top 3 Results

mikey2322

Board Regular
Joined
May 10, 2006
Messages
59
Hi All,

I have a complaint database and need to count/sum various criteria for reporting. To get what I need unqiue values need to be considered and I also want to look at the top 3 results rather than just the top results. I have developed some suitable methods using pivotables etc. but was hoping the community could tell me if I could complete the same tasks using formulas/functions/arrays.

The example and description of what is required can be downloaded from the following link.

https://www.dropbox.com/s/ru06ofy2uicfjjr/Example.xlsx?dl=0

ANy help would be greatly appreciated!

Mike
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

BrianExcel

Well-known Member
Joined
Apr 21, 2010
Messages
958
I would think the way you're doing it now with PivotTables is one of the most effective methods.

An easy way to see the top values is to use the "Large" function. That doesn't get you to the unique values.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,913
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top