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

Any help greatly appreciated

Reply
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