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