JasmineCorp Directory   
  
Usenet News Group Archives!!!

Usenet Groups:

 

 

 

 

 

Re: Graphing frequency of a column of numbers
--------------------------------------------------------------------------------------------
Newsgroup: microsoft.public.excel.misc
Posted by: Ray Rogers
2007-05-19 15:47:45

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.
--
Ray

--
Ray Rogers
"Gus" wrote in message
news:%239q5wWemHHA.3588@TK2MSFTNGP02.phx.gbl...
> 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
> news:B73FC4C9-3392-4D99-913F-14BF81B22E51@microsoft.com...
>> 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
>>
>> 0
>> 0
>> 1
>> 1
>> 1
>>
>> 1
>> 1
>> 2
>> 2
>> 3
>> 3
>> 3
>> 4
>> 4
>> 6
>> 7
>> 7
>> 12
>> 20
>> 23
>> 24
>> 29
>> 31
>>
>> --
>> Ray Rogers
>
>

 

 

 

More >> 

Domain Registration:
.com .org .net
.info .biz .us