Hi,
I am curious to know if there is a command(s) in Excel which can be used to divide the numbers in a sorted list into equal bins?
For example if I have a list of 100 numbers I would like to divide them into 5 groups of 20 numbers each starting with the smallest 20 in the first bin and proceeding to the largest 20 in the last bin.
Thanks for your help!
Bookmarks