Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Effective method to paste array formula
Hi,
what i have is this array formula =IF(ISERROR($E2),"",IF(ISNA(MATCH(1,($A$2:$A$15=$E 2)*($B$2:$B$15=F$1),0)),"",MATCH(1,($A$2:$A$15=$E2 )*($B$2:$B$15=F$1),0))) What i am trying to do is to paste the formula into cells in the F to H column. I know that i have to press cltr shift enter to insert array formula. I trying to find out whether anyone has any method of pasting the formula into the cell. I have in total 4 column and 10000 rows. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Effective method to paste array formula
Ordinarily, if an array formula has already been successfully entered
in a cell, all you have to do is copy it. The "array" character of the formula will persist. From what I see here, the $$ are all OK, suitable for a 2-D calculation. So, all you have to do is: Select single cell with array formula Copy Select all destination cells Paste (or use the autofill handle to copy) HTH Kostis Vezerides |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Effective method to paste array formula
Thanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formula Limits (around 2800 or so) ? Lotus DSUM has no problems with it ! | Excel Discussion (Misc queries) | |||
Question to Bob Phillips (or whoever...) | Excel Worksheet Functions | |||
Array formula returning wrong results | Excel Discussion (Misc queries) | |||
Array Formula | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |