Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Group, As a test engineer I must compile and crunch large amounts of data (up to a million rows of data) prior to a new product launch. In the past we (I) manually separate, sum, analyze numbers. With my new found application called VBA I'd like to perform this number crunching in Excel. Now I know Excel has a row limit size. Once each group of data is parsed into columns, my net would be only several hundred thousand rows with the rest of the data being discarded. My question, is this possible in Excel? And if it isn't what can I use as an intermediate step before crunching in Excel? Tony -- ajocius ------------------------------------------------------------------------ ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695 View this thread: http://www.excelforum.com/showthread...hreadid=482412 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Huge files... why? | Excel Discussion (Misc queries) | |||
why do pivot tables create such huge files? | Excel Discussion (Misc queries) | |||
Huge Files Dont Know Why | Excel Discussion (Misc queries) | |||
Saving Excel files takes a huge amount of time | Excel Discussion (Misc queries) | |||
Excel 2000 importing huge ASCII files into different sheets | Excel Programming |