Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using FREQUENCY Function to Count | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Frequency for Histograms in Excel | Charts and Charting in Excel |