Using this formula to obtain latest prices from a spreadsheet
containing 21500 rows of data


=INDEX(B4:B22000,MATCH(J4,A4:A22000,0)*MATCH(MAX(I F(A4:A22000=J4,C4:C22000)),C4:C22000,0))

It works well, but it's refresh/calculation time can border on 10-12
minutes.

Any ideas on using these types of formulas; or methods to speed up the
refresh process?
(2 gig ram, 2.4 Mhz, and not alot of windows open.)

Pierre

I have a spread sheet that takes 30 minutes to refresh. I can't figure out
how to cut down the refresh time. I am downloading stock information off the
web then doing a lot of calculations with the data. I tried changing
calculation to manual (so I could do all the calculations once after I
downloaded the data) but that only cut out 5 minutes. Any suggestions?



"Pierre" wrote:

Using this formula to obtain latest prices from a spreadsheet
containing 21500 rows of data


=INDEX(B4:B22000,MATCH(J4,A4:A22000,0)*MATCH(MAX(I F(A4:A22000=J4,C4:C22000)),C4:C22000,0))

It works well, but it's refresh/calculation time can border on 10-12
minutes.

Any ideas on using these types of formulas; or methods to speed up the
refresh process?
(2 gig ram, 2.4 Mhz, and not alot of windows open.)

Pierre

Doris, You should start your own thread instead of hijacking another and you
should only post in one group. See my answer in your other post. Or, go here
and download some free files. I have some there

goto

and look in the files section. There are several free files.
I have a couple of free files under author donalb36

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Doris" wrote in message
...
I have a spread sheet that takes 30 minutes to refresh. I can't figure out
how to cut down the refresh time. I am downloading stock information off
the
web then doing a lot of calculations with the data. I tried changing
calculation to manual (so I could do all the calculations once after I
downloaded the data) but that only cut out 5 minutes. Any suggestions?



"Pierre" wrote:

Using this formula to obtain latest prices from a spreadsheet
containing 21500 rows of data


=INDEX(B4:B22000,MATCH(J4,A4:A22000,0)*MATCH(MAX(I F(A4:A22000=J4,C4:C22000)),C4:C22000,0))

It works well, but it's refresh/calculation time can border on 10-12
minutes.

Any ideas on using these types of formulas; or methods to speed up the
refresh process?
(2 gig ram, 2.4 Mhz, and not alot of windows open.)

Pierre