Frequency function
 

I was wondering if anyone could be of assistance with the frequency function
in excel. I am trying to reduce data so that i can find out the number of
times a particular results occurs. Every time i use the frequency function it
either repeats the previous cell or returns the culumative frequency, can
anyone help please?

Hi!

Countif or Sumproduct are less complicated!

You need to provide some details.

Biff

"Pritesh" wrote in message
...
I was wondering if anyone could be of assistance with the frequency
function
in excel. I am trying to reduce data so that i can find out the number of
times a particular results occurs. Every time i use the frequency function
it
either repeats the previous cell or returns the culumative frequency, can
anyone help please?

Assuming you want to check the frequency of numbers in a range.

i.e. how many times does 1 through 10 occur in the range.

With your data range in a1:a8000, key in 1,2,3,etc.
in cells b1:b10

Then select C1:C10 and type this in C1 or paste to the formula bar:

=FREQUENCY(A1:A8000,B1:B10)

and press ctrl+shift+enter because it is an array formula.

Will end up with the formula in the 10 cells in Column C surrounded by {} like
the following

{=FREQUENCY(A1:A8000,B1:B10)}


Gord Dibben Excel MVP


On Mon, 18 Apr 2005 10:50:02 -0700, "Pritesh"
wrote:

I was wondering if anyone could be of assistance with the frequency function
in excel. I am trying to reduce data so that i can find out the number of
times a particular results occurs. Every time i use the frequency function it
either repeats the previous cell or returns the culumative frequency, can
anyone help please?