Graphing frequency of a column of numbers

R

Ray Rogers

I'm having difficulty with this, I wonder if someone could help me with it?

I have a column of 80 numbers and I'm trying to graph out how many of each
number there are. The numbers will change over time. I've included an
abbreviated list below to illustrate.

0
0
0
0
<snip>
0
0
1
1
1
<snip>
1
1
2
2
3
3
3
4
4
6
7
7
12
20
23
24
29
31
 
G

Gus

Hi Ray,

One way;
With your numbers in column A.
Put zero in B1 and drag down holding down control as far as is needed.
Then in C1 put =COUNTIF(A$1:A$80,B1) and drag down as far as
the end of column B.
Aternatively use =COUNTIF(A:A,B1) for more flexibility.

This will show the frequency of each number used and zero
for any number not used in column A.

If you don't want the unused numbers to show you could try a similar
approach using advanced filter first.

HTH
Martin
 
R

Ray Rogers

Thank you Gus, that's a good starting point for me. I'll play around with it
and see if it's what I want.
 
G

Gord Dibben

Ray

Check out help on the FREQUENCY function and/or Histograms

Analysis Toolpak add-in must be loaded to use the Histogram under Tools>Data
Analysis.


Gord Dibben MS Excel MVP
 
Top