View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gus Gus is offline
external usenet poster
 
Posts: 3
Default Graphing frequency of a column of numbers

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


"Ray Rogers" wrote in message
...
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

--
Ray Rogers