|
 |
(HerbD) This article demonstrates how to overcome limitations of user defined functions(UDF) in Excel:
--When used conventionally (i.e. not as an array function) UDFs only can return a single value
--When more than one value should be returned this can only be achieved by selecting the correctly sized range in advance and concurrently pressing . This tells Excel that the formula should be used as an Array Formula.
|
|
| | Related Articles - For Members.
|
|
Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content
No Comments/Feedback Posted Yet. Post Your Comments/Feedback
|
|
|
|
|
|
|
