| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Advanced Excel formulas
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 -- Fred |
|
#2
|
|||
|
|||
|
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 "Fred" wrote in message ... 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 -- Fred |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| Suddenly cannot calculate functions or formulas in Excel | Excel Worksheet Functions | |||
| How do I hide formulas in Excel cells? | Excel Discussion (Misc queries) | |||
| How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions | |||
| duplicating excel formulas | Excel Discussion (Misc queries) | |||
Linear Mode
