I have an extremely long column of numbers and i want to determine where those numbers each fall into various ranges. they are a list of times in seconds. i want to know how many fall less than 30 seconds, between 30 seconds and 1 minute, 1 to 2 minutes, 2-3 minutes, and so on. I figure that i can create a nested IF statement in series that will help spit out results into a second column to the right giving a flag as to which range each number falls into. later I'll be able to run a pivot table and tell how many fall into the given ranges taht i specify. I can't seem to get the formula right. is there a better way?
Bookmarks