Sorting to a Frequency Table

anthfiat · General User Joined: 30 Mar 2005 Posts: 9

Hello,

I was jst wondering if someone could help me with sorting of data to class intervals. I have a column of data that I would like Calc to sort into a predifined range of data. Does anybody have any tips. An example would be:

data set: 43, 46, 34, 59, 87, 91, 54, 87, 65, 96, 5, 18, 21, 32, 78, 23, 97

I would like it sorted to class intervals as follows:
Class Interval Frequency
0-9
10-19
20-29
30-39
40-49
50-59
60-69
70-79
80-89
90-99

any help would be greatly appreciated,
Anthony

Villeroy · Posted: Thu Feb 16, 2006 1:22 pm Post subject:

Column A1:A11 has 0, 10, 20, ..., 100
Column B: 43, 46, 34, 59, 87, 91, 54, 87, 65, 96, 5, 18, 21, 32, 78, 23, 97
C1: =MATCH($B1;$A$1:$A$11;TRUE)
returnes the position in sorted A1:A11
D1: =VLOOKUP($B1;$A$1:$A$11;1;TRUE)
returnes the value of sorted A1:A11