Posts by marielinha

Actually Will R just let me know that you can't manually type in the {..} enclosure, result arrays can only be entered by using the CTRL+SHIFT+ENTER buttons, oh yeah and he also let me know tha the ATTACHMENT feature does not work at this time.
Thanks again Will R. :angel:

:coolwink:
To get your results in a set of cells say c1:c5...
...enter your FREQUENCY formula in the FORMULA bar and the hit
CTRL+SHIFT+ENTER
or enclose your FREQUENCY formula in {=FREQUENCY(..:..,..:..)}

so THE RESULTs ARE DISPLAYED IN C1:C5

See attachment!!!

:biggrin:
Thanks to Andy Pope and REM1224 (Ralph)

Kool!!!

I'd like to get the COLUMN number of the cell that contains the MAX value

I know how to get the MAX value, the COLUMN number of a referenced cell, but can I combine these functions somehow?

Thanks in advance,
Marielinha