Hi all,
I have a problem with the the evaluation function which I can't figure out why.
I have the function which looks like:
=INDEX($A$19:$I$39,MATCH("Paid Admissions",$D$19:$D$39,0),COLUMN())
Now I have the same function as text which I am trying to evaluate with a user defined function "evaluation" (same as the morefunc add in) EVAL
INDEX($A$19:$I$39,MATCH("Paid Admissions",$D$19:$D$39,0),COLUMN())
The outcome of the EVAL treats the COLUMN() part as 1 instead of the column in which the eval function is placed.
When I evaluate just COLUMN() it works perfectly.....
Where do I go wrong??
Hope I am being clear enough...
I have a problem with the the evaluation function which I can't figure out why.
I have the function which looks like:
=INDEX($A$19:$I$39,MATCH("Paid Admissions",$D$19:$D$39,0),COLUMN())
Now I have the same function as text which I am trying to evaluate with a user defined function "evaluation" (same as the morefunc add in) EVAL
INDEX($A$19:$I$39,MATCH("Paid Admissions",$D$19:$D$39,0),COLUMN())
The outcome of the EVAL treats the COLUMN() part as 1 instead of the column in which the eval function is placed.
When I evaluate just COLUMN() it works perfectly.....
Where do I go wrong??
Hope I am being clear enough...