Home |
Search |
Today's Posts |
#11
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Sat, 25 Oct 2008 11:21:55 -0700 (PDT), Harlan Grove
wrote: Ron Rosenfeld wrote... ... Why is Split wasteful? It does more than necessary. It locates every \ and creates an array, neither of which are necessary, both of which require execution time and additional memory usage. That makes sense. And in running a timing routine on both, the Split seems to take orders of magnitude longer than your routine. And is there someplace I can read about this issue (wastefulness) in general? Benchamarking, both for speed and resources use. Web search on programming and either benchmarking, efficiency or performance. Thanks --ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Returning left part of cell before a character | Excel Discussion (Misc queries) | |||
Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
part of string | Excel Programming | |||
Use part of string | Excel Programming | |||
Returning an Array as part of creating a cell formula | Excel Programming |