LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
frequency a number repeats in a column Ken Excel Worksheet Functions 5 March 8th 07 03:12 AM
how do I get the frequency of letters in a column? Jim Excel Discussion (Misc queries) 4 March 29th 06 08:18 PM
How do I count the frequency of a given number in a column? dykstra_sj New Users to Excel 6 February 2nd 06 08:32 PM
How do I make a graph of the frequency names come up in a column? gziomek Charts and Charting in Excel 3 December 28th 05 11:55 PM
Count the frequency of all numbers in a column horatio New Users to Excel 3 May 17th 05 02:38 AM


All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"