Tom,
Of course it is relevant whether you can observe the difference or not. A
task that takes 1ms or one that takes 5ms, in most circumstances who cares?
And that was the point of my original response,... in most cases.
Nobody is arguing about pointing other aspects out, as I said in my reply,
but for you to suggest that we were being misleading, especially considering
the statements that I added to my post is scurrilous.
I note that there have been thousands of previous post that have offered
array formulae after non-array formulae which you didn't decide to jump in
on, now I wonder why that might be?
I create spreadsheets with more than 55 array formula on a routine basis. I
suspect we use spreadsheets for much different purposes.
Oh dear, oh dear!
You attempted to belittle the assertion: "Like anyone will notice in 99.99%
of the cases." and appeared to take it as some type of personal
disparagement.
Accepted that, although it was not meant that way, it could be taken as
such. My error and apology. But if that was your original beef, why not just
say so, rather than accuse me of misleading anyone? Not very grown-up.
This whole thread beyond my post is pretty much a waste of time in my
opinion.
I think that that sentence says a lot about you. And yet you go on ( and
on).
If you are just offering for variation why the big to do about
there is no difference -- when there is? You state you don't have much
experience here, so why argue.
I don't think there was a big to-do, just trying to counter a nasty
statement about misleading people.
This is the second time that we have been here. I know that your Excel
knowledge is excellent, and that the help that you give in these NGs is
something special, but you seem to go seeking to criticise. I well accept
that I may be well off-track here, but I get the impression of a pompous,
vindictive nature in yourself.. I fully expect that this will lead to you
seeking me out even to criticise, but I can handle that.
--
HTH
-------
Bob Phillips
... looking out across Poole Harbour to the Purbecks
Tom Ogilvy said:
Whether you can observe the difference or not, and as a rough estimate it is
~ five times slower than the method proposed by Aladin - a fast machine does
not change that and as I stated, I only used 55 to make the difference
timable - even one instance would be ~ five times slower (sheesh). Has
nothing to do with complex spreadsheets - it is slower in each instance -
whether it is something that needs to be considered would be up to the
user - but it wouldn't be considered if they didn't know. And there is
nothing wrong with me telling the OP that the array formula is slower.
I create spreadsheets with more than 55 array formula on a routine basis. I
suspect we use spreadsheets for much different purposes.
"Now hold"
And all I said was:
Note that the array formulas suggest [sic] will be much slower to
recalculate than
Aladin's formula.
I didn't criticize anyone's submission in my post or say that an alternative
solution shouldn't be offered.
You attempted to belittle the assertion: "Like anyone will notice in 99.99%
of the cases." and appeared to take it as some type of personal
disparagement.
This whole thread beyond my post is pretty much a waste of time in my
opinion. If you are just offering for variation why the big to do about
there is no difference -- when there is? You state you don't have much
experience here, so why argue.
Regards,
Tom Ogilvy
