LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 27th 06, 04:23 PM posted to microsoft.public.excel.misc
Posts: n/a
Default 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

Any help greatly appreciated

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking-up Columns w/calc'd Values ONLY to Calculate Average sony654 Excel Worksheet Functions 5 April 21st 06 06:21 AM
Multipying columns that contail null values ChuckW Excel Discussion (Misc queries) 1 September 7th 05 01:13 AM
join columns, keep both values FourPenny New Users to Excel 5 May 31st 05 01:36 AM
Totalling values across columns Glenn Excel Worksheet Functions 3 January 26th 05 02:47 AM
Creating a chart with values from two columns Ivan Charts and Charting in Excel 2 December 12th 04 08:31 PM

All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017