error is :

Formula You typed Contains an error

For information about fixing common formula problems Click Help
To Get Assistance in Entering a function click OK then click Function
on the Insert Menu
If you are not trying to enter a formula , avoid using an equal sign or
minus sign or preded it with a singl quotation mark ( ' )

regards
Jay
Leo Heuser wrote:
If you enter B *directly* into the formula, you have to tell
Excel, that it's a string ("B"), so the formula becomes:

=MAX(FREQUENCY(IF(L9:L64999="B",COUNTIF(OFFSET(L9, ,,ROW(INDIRECT(1:"&ROWS(L9:L64999)))),"<"&"B")),R OW(INDIRECT("1:"&ROWS(L9:L64999)))-1))

If you get errors of some kind, please disclose
what the error says.

Leo Heuser


Followup to newsgroup only please.
"Jay" skrev i en meddelelse
ups.com...
here how i entered the forumula

MAX(FREQUENCY(IF(L9:L64999=B,COUNTIF(OFFSET(L9,,,R OW(INDIRECT(1:"&ROWS(L9:L64999)))),"<"&B)),ROW(IN DIRECT("1:"&ROWS(L9:L64999)))-1))

regrds

Jay