Find predominant number in list

**littler** · 10-02-2008, 05:51 PM

Hello, I am a new forum user and not very good at the programming lingo and the logic behind it.

I have a basic understanding of simple calculations but beyond that I am kind of lost.

I have a list of numbers ranging from $9,516 to $110,000 and I am trying to figure out a manner to determine what is the most common number rounded to the nearest $10,000.

When I use the mode function it only tells me the absolute number that has the most occurences. I am trying to determine the predominate group in the overall range. Basically I want to count the number of occurences in the forty thousand range, fifty thousand range, etc. so I can determine what is the most popular $10,000 range.

Any and all help is most appreciated. I have attached the sheet I am working with. Thanks!