I've got a set of numbers from 0 about 20,000, most less than 500. i want a chart that displays the number of items in the range 0-99, 100-199 etc. Is there a way of doing with without having to code all the alternatives in an elaboate if statment & what's the excel formula for 'between ?!?
As ever, all hlpgratefully received.
As ever, all hlpgratefully received.