OK i have a formula (from my previous thread: Column Comparisons) that compares two columns for a certain value.

I now wish to fully automate my data population sheets.

I have 3 colulmns: Category; SubCategory; Problem Type.

Lets say that Category holds 3 types of data: Printer; Networks; Enquiry. Problem Type holds: break/fix; Configuration; Error Msg; hangups. and the Sub Category holds: Printer Hardware; Printer Software; Network Hardware; Network Software; complaints.

I wish to create a formula that looks at these values and creates a tables for each Category and sub divides it by SubCategory and then lists each problem type.

For example:
Category = Printer
SubCat = Printer Hardware
Problem Type = break/fix; Configuration; Error Msg; hangups.

The formula use these fields to match and add the total amount for each problem type.

Quite a lot to ask I know but this would really make my tool completely automated without the need to add new problem types and regroup by category and sub cat every time the data changes.

Any Ideas?

Thanks in advance!!!!!