Oct 20 2021 07:24 PM
IMHO, only choice for users (VBA restricted by company policy) is labour-intensive naming intuitive to other users; one challenge: Unicode required to emulate Excel function style.
Example is Excel function SUBSTITUTE not yet capable of array input.
My formula
Excel Function Syntax | SUBSTITUTE(text, old, new) |
My formula name for array inputs; same syntax | SUBSTITUTE﹙txt﹐﹛old﹜﹐﹛new﹜﹚ |
Brackets and curly braces are restricted by current Excel; I need to spend time finding Unicodes compatible with Excel Name Manager. I wish Excel Nam Manager can support better on Unicodes to improve:
Oct 21 2021 02:37 AM
Oct 21 2021 07:33 PM