Bernie Deitrick wrote...
Then I should have been clearer: "No, there is no built-in Excel
function,
but you can use ....."
....
OK, but there's a trade-off between udfs and long formulas. Formulas
need to be really long, really complicated and process LOTS of data
before they become anywhere near as slow as udfs. And formulas using
only built-in functions don't cause problems with macro security
settings.
|