Forum Discussion
KellyRosenthal
Dec 01, 2021Copper Contributor
Trying to Group a Range of Numbers in Excel
I have an array of numbers below and I want to see groupings if I were to group into 4 bins/buckets or if I were to group them into 5 bins/buckets or 6 bins/buckets and so forth. For each scenario, ...
mtarler
Dec 01, 2021Silver Contributor
KellyRosenthal I attached an example. There are many questions that I could ask to clarify but hope I made OK assumptions. A couple key ones include that by x bins you want them = based on the range of the data. i also assumed you have excel365 but then had to do a fill down any how.