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
Bookmarks