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