Here is the template that I use. It uses the Query function to do the analysis . The query in the analysis sheet is in cell A27 and you just need to modify it however you want .
The input is done in the all data sheet . Input the data in the fields in this sheet except for Column B.
Let me know if you have any questions.
Jim
|