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
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