Copying an array formula...
Hello,
EXCEL 2003 --
I have the following formula:
={index('SHEET1'!$A$1:$AK$12000,MATCH(C2&"",'SHEET 1'!$D$1:$D$12000&'SHEET1'!$E$1:$E$12000,0),30)}
This s located in cell b2 and in cell c2:j2 I have the same formula with a
different number at the end.
Issue:
I need to copy these cells B2:J2 to the following range
B4:J12500 -- However, when I do this the computer stop responding and excel
seems to crash. I've done this for the past 3 days leaving the computer
running for a maximum of 4 hours.
Help. Is there anyway to do this quicker.
Thanks
Dennis G.
|