I have a grid of numbers.

I want to create a new grid which has corresponding frequencies for the
original grid.

In other words, if A1 = 10, and my data spreads from A1 to G100, then I want
A1 of the new grid to = how many times 10 appears in the A1 to G100 dataset.

Anyone know how to do this without having to create a histogram and manually
matching my numbers with the histogram's frequencies? My dataset is becoming
too large to do all that matching (and I make errors after my eyes go buggy).

Okay, so I discovered Countif. How do I copy the formula so the range
indicated doesn't change, but the criteria cell does?

"Rothman" wrote:

I have a grid of numbers.

I want to create a new grid which has corresponding frequencies for the
original grid.

In other words, if A1 = 10, and my data spreads from A1 to G100, then I want
A1 of the new grid to = how many times 10 appears in the A1 to G100 dataset.

Anyone know how to do this without having to create a histogram and manually
matching my numbers with the histogram's frequencies? My dataset is becoming
too large to do all that matching (and I make errors after my eyes go buggy).

Now I'm very happy.

If anyone's paying attention: Use dollar signs in the range, and they'll
stay put.

"Rothman" wrote:

Okay, so I discovered Countif. How do I copy the formula so the range
indicated doesn't change, but the criteria cell does?

"Rothman" wrote:

I have a grid of numbers.

I want to create a new grid which has corresponding frequencies for the
original grid.

In other words, if A1 = 10, and my data spreads from A1 to G100, then I want
A1 of the new grid to = how many times 10 appears in the A1 to G100 dataset.

Anyone know how to do this without having to create a histogram and manually
matching my numbers with the histogram's frequencies? My dataset is becoming
too large to do all that matching (and I make errors after my eyes go buggy).