I have a list of data that i'd like to organize in a chart that shows how many times a number appears between a specified range. For example, i have a list of 123 prices. I'd like to know how many prices (and what percent) of the list is comprised of these price ranges:
0-50
51-100
101-200
201-300
300+
I can solve this using the countif function for the upper and lower portion of the range and then subtract out the excess from the total, but i was hoping someone would know of a different function that would allow me to do this in a much simpler fashion. Thanks!
Bookmarks