Please help sorting data by range

[ExpNewbie]

Hi Everyone,

I noticed your reply to post by another member and thought you might be able to help me. I have 12 columns and 26,736 rows of data. One column scores each row (customer sales data) by a range going from 310 -800. What I need to do is seperate, count and chart row elements that fall in the following ranges:

310-380
381-450
451-520
521-590
591-660
661-730
731-800

So I'll need to gather all the row elements that fall in the 310-380 range for instance and then chart them?

Maybe once I sort the row elements by each range I should have them output to a seperate sheet?

Please any help is appreciated.

Thank you,

Paul

[Greg M]

Hi there,

Would something like the attached help?

Please contact me if you need clarification.

Best regards,

Greg M