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?
|