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