Advanced Excel formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a column of student names, column by gender either M of F(another
column) and they recieved a rating profile(anther column;ratings 0,1,2,3, or
4). I want to chart the number of males with a 1 rating, 2 rating, 3 rating
etc. Also want to chart the number of females with 1 rating, 2 rating, 3
rating. What would be the formula or formulas to achieve this.
Thanks
 
I would CONCATENATE the Gender and Ratings columns into a helper column
and then do Data > Subtotals > ForEachChangeIn: the helper column >
UseFunction: Count > AddSubtotalTo" > Rating..........

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel 1
Excel lookup 2
Excel Consecutive counts with conditions in excel 0
Excel Formulas 3
formula 3
Utilizing a macro for a datasets that don't have a fixed number of 1
Help with Averageif Formula (don't think I should use Averageif) 5
IF function 3

Back
Top