Array formula in a makro want work
On Sun, 26 Aug 2007 22:34:15 -0700, Makelei
wrote:
Hi,
I have this formulae:
=IF(LEFT($D10,4)="Ext-",SUM(IF(Need!$F$8:Need!$F$21<"",IF(Need!$G$8:Nee d!$G$21=RIGHT($D10,LEN($D10)-SEARCH("
",$D10)),IF(Need!$E$8:Need!$E$21<$B$4,IF(Need!$E $8:Need!$E$21<$B$3,IF(Need!$E$8:Need!$E$21<$B$2, IF(Need!$E$8:Need!$E$21<$B$1,Need!T$8:Need!T$21,0 ),0),0),0)))),SUM(IF(Need!$F$8:Need!$F$21="",IF(Ne ed!$G$8:Need!$G$21=$D10,IF(Need!$E$8:Need!$E$21<$ B$4,IF(Need!$E$8:Need!$E$21<$B$3,IF(Need!$E$8:Nee d!$E$21<$B$2,IF(Need!$E$8:Need!$E$21<$B$1,Need!T $8:Need!T$21,0),0),0),0)))))
I am not able to activate that formula in array {} format. I should be able
to so that I get the right results. It is part of a macro and macro does not
accept that as an array. I have tried to record that, no acceptance. Problem
seems to be in this part:
IF(Need!$G$8:Need!$G$21=RIGHT($D10,LEN($D10)-SEARCH(" ",$D10)
When activating cell content and with shift+ctrl+enter it will be an array
and will give right results.
How could I resolve this problem?
Thanks in advance
MakeLei
Take a look at HELP for the FormulaArray Property. Your formula will need to
use the R1C1 reference style.
--ron
|