ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Distribute values evenly in two columns (https://www.excelbanter.com/excel-discussion-misc-queries/85595-distribute-values-evenly-two-columns.html)

MIckeyLove

Distribute values evenly in two columns
 
OK - I'll try and make this as clear as possible.

I have a column of numbers. Assume the numbers add up to equal 1000.

I want to distribute these numbers into two different columns so each column
adds up to (or as close as possible to) - 500. The numbers themselves can't
change. Goial seek doesn't quite work as it can only change single cell
values.

Any help greatly appreciated


All times are GMT +1. The time now is 10:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com