Elijah,
Example workbook is underway to you.
Cheers.
Aladin
Elijah Wrote:
Hi Aladin,
I started to use your implementation - but I got confused with the
instructions you gave. I will definitely try it again to see if it
overcomes
my current problems - and will post back to you. Do you have a prepared
xls
example of the technique which you could email? )
I opted for the quick (and possibly inefficient) fix because at the
time I
had a deadline looming.
I am noticing though that my xls is considerably slower than
previously.
Elijah
"Aladin Akyurek" wrote
in
message ...
Elijah Wrote:
Ok - getting rid of the error is probably a better approach.
The errors come from an extracted list of customer names using the
array formula you provided before Frank:
{=INDEX(Custnames,SMALL(IF(RngA="Include",ROW(RngA )-3),ROW(1:1)))}
I extended the formula down further than was neccessary to
acomodate
when the customer list growths. So that's were the #NUM! errors
come
into play. I guess I don't neccessarily need to do this - but I
want
to automate my xls as much as possible for when others use it.
If there is a solution it would be helpful, - but I guess not the
'end
of the world' :-)
...
Is there a particular reason for not implementing the formula system
I
suggested in
http://www.excelforum.com/showthread.php?t=276162
to extract the customer list of interest and associated values?
I'm saying this in view of the fact that you are attempting to use
an
inefficient (slow), non-robust extraction formula which moreover
produces #NUM! errors that thwart further processing of the
extracted
list. Expanding the formula in question with error trapping using
ISERROR makes it doubly inefficient.
--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php...fo&userid=4165
View this thread:
http://www.excelforum.com/showthread...hreadid=318967
--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php...fo&userid=4165
View this thread:
http://www.excelforum.com/showthread...hreadid=318967