Quote:
Originally Posted by swordo84
Excel people - I call on you for help with what I suspect is an easy forumla I just can't wrap my head around.
I have 18,000+ rows of simple number (no decimal points). I need to gather data on how many of these are <= 30, 31-60, 61-90 etc. etc. etc.
Help, please?
|
Are you very good with pivot tables? You could create a pivot table, then set the rows to grouping by those intervals. That's the easiest way.