On Sun, 6 Apr 2008 10:05:00 -0700, Lori wrote:

i may be missing something but how about for the lower bound:

=MODE(FLOOR(A1:G1,50))

and adding 50 for the upper bound. Obviously replace 50 by a cell reference
to make it a variable bin size.

However it's not clear from the question whether 450 should be in 450-500 or
400-450, if the latter use CEILING instead of FLOOR to obtain the upper bound
and subtract 50 for the lower bound.

Much simpler!
--ron