Re: Problem with SMALL function and multiple same values

Hello Biff,

You are right with your count of references, I think. But the
comparison of the runtime of our approaches depends on how many calls
to SMALL you have to add to your (admittedly, quick) formula, I guess.
For 1,000 cells your formula would only need 1 msec (on my 2 GHz dual
core) but 1,000 calls to SMALL (or one corresponding array formula)
would need 350 msec. My formula would need 220 msec, plus 1,000 INDEX-
MATCH calls would add 25 msec. BTW: Your RANK-COUNTIF approach would
need only 120 msec...

If the number of SMALL calls is low and if distances are given with
less than 7 decimals (10 was wrong) then your approach seems to be
preferrable.

Regards,
Bernd
.

Relevant Pages

  • Re: Have you ever wondered.....
    ... I think I now understand that your wbt clock measures ... I mean that the rulers are objects which produce distances which we then use as references ... objects that produce a motion which we then use as a reference to measure other motions in ...
    (sci.physics.relativity)
  • Re: A function to Turn Formula into Text?
    ... a cell referenced was not rounded and has decimals like 1/3 would, ... 'substitutes the contents of cell references for the references ... Dim str As String ... 'Pattern should recognize only cell references in range A1:IV65536 ...
    (microsoft.public.excel.misc)
  • Re: The oldest explosion in the universe
    ... If you would like references, ... in the context that you used it. ... denser in the past. ... all boils down to the way we measure distances. ...
    (sci.physics)
  • BGP Route reflectors synchronization problems
    ... synchronization problems of BGP route reflectors that are connected by ... links at distances typically greater than 1000 kilometers. ... and if there are some references or pointers to that problem ...
    (comp.dcom.sys.cisco)
  • Re: Distinct distances on a chessboard
    ... I don't know, but possibly, as there are only 33 possible distances. ... For larger grids, I was hoping someone had references - surely this ... J K Haugland ...
    (sci.math)
Loading