Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
frequency a number repeats in a column | Excel Worksheet Functions | |||
how do I get the frequency of letters in a column? | Excel Discussion (Misc queries) | |||
How do I count the frequency of a given number in a column? | New Users to Excel | |||
How do I make a graph of the frequency names come up in a column? | Charts and Charting in Excel | |||
Count the frequency of all numbers in a column | New Users to Excel |