P
Pierre
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(IF(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
containing 21500 rows of data
=INDEX(B4:B22000,MATCH(J4,A4:A22000,0)*MATCH(MAX(IF(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