Frequency Headache

[Guest]

I have a grid of random numbers. What I want to do is make a new,
corresponding table that has those numbers' frequencies from the initial
dataset.

So, if I have a row 1,2,3,4,5, the first row in my frequency table shows the
frequencies for those numbers, whatever they might be regarding the entire
set of numbers.

I'm just wondering if there's a more automated way of doing this than
running the historgram function and then manually matching the frequencies
with the original numbers to come up with my table. My dataset is growing,
so that's becoming too time-consuming.

Oy.

 

[Guest]

Countif works wonders.

 

[Guest]

Of course, I can't keep the range constant while increasing the criteria cell
with the autofill feature. Anyone know how to do that?

 

[Guest]

Fine. I figured it out. Put dollar signs in front of the range ($C$3, e.g.).

Thanks.

 

[bulaman001]

Hi; Does anyone have any ideas to help me with a formula that I can use
to count text (counties) and to total the count numerically in a
seperate cell?

 

[Pete_UK]

Use the COUNTA( ) function, along the lines of:

=COUNTA(A1:A20)

if your text is in cells A1 to A20.

Hope this helps.

Pete

 

[Guest]

I don't, but you should start a new thread.