Excel Formula

[wright]

I have column A with a set of 300 or so numbers ranging from 0 to 1,500,000.
I want to be able to take all these numbers and group them in alotments of
600,000 while trying to optimize the total # space. Granted anything above
600,000 can't be used

Hopefully this makes sense

 

[Bob Buckland ?:-\)]

Hi Wright,

You may want to also post this in the MS Office Excel discussion group using the link below and include there the version of Excel
you're working with.

=============
I have column A with a set of 300 or so numbers ranging from 0 to 1,500,000.
I want to be able to take all these numbers and group them in alotments of
600,000 while trying to optimize the total # space. Granted anything above
600,000 can't be used

Hopefully this makes sense >>
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com