Thread: Any formula to return the most frequent bin range?
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Any formula to return the most frequent bin range?
On Sun, 06 Apr 2008 11:26:16 GMT, Lars-Åke Aspelin
wrote:

I think there will be a problem with your formula Ron, if the minimum
value in the range is less than BinSize. The FLOOR function then
yields 0 and that will annoy the INDIRECT function.

Lars-Åke

You're correct. I had not considered that possibility.

--ron
Reply With QuoteReply With Quote