Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array Formula | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Worksheet Functions |