I am using to Excel to analysis data from SQL Server because Excel is more powerful and easier to use. I am looking to make my work more efficient.

Currently I am taking my data which has the following fields :

company_code, deal_id, ***_code, unisex, issue_age, level_term_period, underwriting_class, rider_code, table_rating, policy_year, band, face_amount, premium_rate, calculated_premium_rate, premium_rate_variance
I am trying to see if any patterns revolved around the premium_rate_variance field which can be 'Y' or 'N'. Right now I'm sorting it manually by each variable, then if nothing shows up, break my sort down further.

So I will look if said company_code has more premium_rate_variance equal to 'Y' than 'N'. If that's not the case, see if company_code and deal_id has more. And so on.

I am not sure how to go about automating this process, and if it will be a macro or if it can be done using formulas. I posted this in the General forum to get some insight and advice on where it should be. Thanks for the help

Scott