Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
D$12) and press Ctrl+Shift+Enter. This one function returns an entire range of
results. In the image below, I’ve added a comment about the meaning of each
result. Note that any entries in the last row are for scores above the largest bin
value.
If you don’t need a "live" formula, it is faster to create the frequency distribution
using a pivot table. Create a pivot table from A1:A1001. Put Result down the
row area. Put Count of Result in the data area. Right-click the fi rst result in the
row area of your pivot table and choose Group and Show Detail, Group. In the
Grouping dialog, choose to group from 1 to 110 in groups of 10. The result is
shown below.
 
Search JabSto ::




Custom Search