problem with FREQUENCY

  • Thread starter Thread starter Gautam
  • Start date Start date
G

Gautam

i would like to enter the array formula for frequency in cells B34:F34
(ROW 34) as follows:

{=FREQUENCY(B5:Q5,B32:F32)}

however, i get a bunch of zeros. if, however, i enter the formula in a
single COLUMN, such as B34:B38, i get the correct answer.

so my question is, can array formulas be entered only in a
"column-wise"? if not, what am i doing wrong?

gautam.
 
Try:

=TRANSPOSE(FREQUENCY(B5:Q5,B32:F32))

(still array entered)

Select the cell with your formula and hit F9.

You'll see something like:
={3;4;3;4;2;0}

You'll see commas if you do the same with the =transpose(frequency()) version:
={3,4,3,4,2,0}

Those semicolons mean that you get a vertical list.

Another hint is in Excel's help for =frequency()

Calculates how often values occur within a range of values, and then returns a
vertical array of numbers....

<vbg>
 
Back
Top