Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi and thank you for your time.
I have the following data in a spread sheet A B C 0 50 F 50 52 D- 52 56 D 56 59 D+ //this continues through A+ it's our schools marking system. On another sheet in the same workbook I have my 300 students listed with their grade inputted as well. LastName FirstName Grade Smith John 65 --------------------- What I would like to do is find out the frequency of grades on another sheet that might look like Grade Frequency A 12 // where 12 means that 12 students recieved a mark between 85 and 89 TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FREQUENCY across multiple worksheets | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
how do get the frequency in 2 columns | Excel Worksheet Functions |