I need a formula for taking many numbers (thousands) and grouping them into 100 equal size groups. Group 1 will have the smallest numbers, group 100 will contain the largest numbers.
I need a formula for taking many numbers (thousands) and grouping them into 100 equal size groups. Group 1 will have the smallest numbers, group 100 will contain the largest numbers.
A formula won't do it.
I assume you have the numbers in a column in a spreadsheet.
so what you need is a macro.
The question is how do you want the output?
Numbers separated with thick borders in column?
numbers in separate rows for each group?
As 100 strings?
As named variables.
The options are endless.
Please provide more information.
I would like the output in a column next to the first column of numbers, with the second column being the group number that corresponds to the group that the first column number was put into.
Example: the range of the original column is 100 to 200, the groups of column 2 are 1 to 100.
Column 1 Column 2
200 100
100 1
137.56 40
185.28 83
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks