View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jimF
 
Posts: n/a
Default Sorting 1 column into two

I have a list of numbers in 1 column that total to a specific number. I want
to create two separate columns whose indidvdual totals are as close as
possible to the original total and the two new column lengths are as close as
possible.