Arranging x numbers in y groups with an approximate sum of z

		Microsoft Office Forums > Microsoft Excel > Excel
Arranging x numbers in y groups with an approximate sum of z

FAQ

Thread Tools

Display Modes

12-11-2014, 10:14 PM

hiwire03

Windows 7 32bit Arranging x numbers in y groups with an approximate sum of z

Office 2013

Novice

Join Date: Dec 2014

Posts: 17

Arranging x numbers in y groups with an approximate sum of z

I have ''x'' set of numbers (say { 1.3, 2.7, 3.8, 1.9, 8.2, 1.5, 18.4, 22, 5.3}) which I want to group in ''y'' (say 3) sets with each set totaling to an approximate value of ''z'' (say 7).

How can i do this using excel?

Tags

grouping, rearrange

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re-arranging data output into useable format	bremen22	Excel	2	11-18-2013 10:32 AM
Bar Graph in Groups	Alaska1	Excel	3	12-17-2012 05:20 PM
Effects list re-arranging	Buzzman	PowerPoint	0	11-21-2011 08:46 PM
Arranging Into Groups	skoz55	Excel	1	09-07-2011 12:02 AM
Some contacts are listed in groups I don't want	ironwoods	Outlook	0	07-29-2010 04:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:59 PM.