Greetings,
I need help with something I was tasked to do for work. I'm familiar enough with Excel to know this is possible, but not sure how to develop the formula. I have a list of items with prices that I want to group into 4 similar totals. For example, I may have 12 items (no particular order) that I want to divide up into 4 groups, each with a total cost somewhat close to the other groups. Excel will look at the list of cells with numbers, and change the order into 4 groups each with similar totals. I hope that makes sense.
Don't see an option to post an attachment, but have a simple example I can provide.
Any help greatly appreciated.
Thank You,
I need help with something I was tasked to do for work. I'm familiar enough with Excel to know this is possible, but not sure how to develop the formula. I have a list of items with prices that I want to group into 4 similar totals. For example, I may have 12 items (no particular order) that I want to divide up into 4 groups, each with a total cost somewhat close to the other groups. Excel will look at the list of cells with numbers, and change the order into 4 groups each with similar totals. I hope that makes sense.
Don't see an option to post an attachment, but have a simple example I can provide.
Any help greatly appreciated.
Thank You,