Frequency function

[Guest]

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?

 

[Biff]

Hi!

Countif or Sumproduct are less complicated!

You need to provide some details.

Biff

 

[Gord Dibben]

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