Need to process more data than excel can handle

dal777

New Member
Joined
Dec 6, 2005
Messages
5
Hi all, I'm trying to process so much data that excel just stops responding, so what I need to do is process smaller amounts at a time and store the result on a seperate sheet. This is what the data looks like when it's imported from a .txt file :

KMTN 39.32566412 -76.41376644
{
RUNWAY 5016
PARKING 18
PARKING 31
PARKING 10
PARKING 10
PARKING 10
}

The imported data goes in ROWS A B C, the processed data goes in - J L N P R T V X Z AB AD AF AH AI AJ


As you can see it's only 3 columns wide but there's about 500,000 lines of it .The above data will form 1 record once processed but the amount of rows in a record varies. Every record ends with a } symbol.
I know excel cant handle more than about 65,000 rows - thats not a major problem, I'll split the txt into 10 files of 50,000 if need be.
How do I get excel to proccess a record i.e - a varying number of rows - typically between 5 & 50, put the result on another sheet then proccess some more. I've not got a clue about VISUAL BASIC or macros which I suspect is where the answer lies.
Any help appreciated - thanks.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
You would need to show us a sample of how the data looks once imported, and how it looks once it is "processed" by excel.

And yes, the answer is VB, or possible a Pivot table.

You could throw all the imported data into a pivot table and see if that lets you spin it for the desired output. Excel's help file is pretty decent on using pivot tables.
 

dal777

New Member
Joined
Dec 6, 2005
Messages
5
Thanks for the quick reply there Gibbs.

Okay here is the imported data :





And the output looks like this :

[/img]
 

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
Okay, now explain the logic of how the information translates...I looked at it and all I can see is that you count the occurrence of the word runway as a count...
 

Watch MrExcel Video

Forum statistics

Threads
1,118,286
Messages
5,571,313
Members
412,382
Latest member
Langtn02
Top