Excel 2003 question

[mcseguy9]

Let's say I have an Excel spreadsheet with a column full of different numbers. So each cell has a different random number in it. The numbers represent a file size in kilobytes. Let's also say there are a few hundred cells in this column all with different values. Is there a way to easily put groupings of these cells together through a formula or something so that they add up to no more than 3 gigs but not much less than that, either? So if I have 100 cells, all with different values, what I want to do is run some command that will tell me that "these cells" added together would come out to no more than 3 gigs. I hope that makes sense.

[Steve R Jones]

Do you need to do this more then one time?
Meaning, after you find your three gigs do you need to look through the remaining numbers for another three gigs?

If just one time, sort em and eyeball it...Should be able to get real close pretty quickly.

[mcseguy9]

Yep, I need to do this over and over again so that I have multiple sections of cells grouped together that come close to the 3 gig mark. Otherwise you're right, it would be easiest to eyeball it.

[jdc2000]

A VBA Macro would be your best bet for doing this.