Correct, that would be ideal with more emphasis on each list totaling 1000
sec and less emphasis. on each being 10 items long.

Thanks for your assistance

"CLR" wrote:

So, ideally, you would wind up with two new lists, each of 10 items,
extracted from the 20 item list in column A and each totalling 1000
sec.............is that it?

Vaya con Dios,
Chuck, CABGx3




"jimF" wrote:

My single column is a list 20 random entries(in seconds) that total 2000 sec
. From that single list, I want to create two separate lists that total
close to 1000 seconds each and, if possible, have the two new lists with
close to equal number of entries.

"CLR" wrote:

Please supply more details........

Vaya con Dios,
Chuck, CABGx3



"jimF" wrote:

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.