Hi Daniel
thanks for the hint. You're right, my original formula works only if
there're no blank rows in between.



--
Regards
Frank Kabel
Frankfurt, Germany

"Daniel.M" schrieb im Newsbeitrag
...
Hi Frank,

You should always use ROWS(A1:A20) instead of COUNTA(A1:A20)

because the result of MATCH() can produce a number higher than
COUNTA().
Therefore the FREQUENCY() will distribute ALL those values in the
SAME bucket
(the last one).

Ex with A1:A5 range:

blank 34
blank 34
blank 34
1 200408
2 200408

Returns 1 but should return 2.

Regards,

Daniel M.