Re: Top 10 Text Values

In article <ukV217bDGHA.208@xxxxxxxxxxxxxxxxxxxx>,
"Harlan Grove" <hrlngrv@xxxxxxx> wrote:

> >Although, A1 doesn't necessarily need to be blank. It could contain a
> >header, which in all likelihood would be the case, and wouldn't affect
> >the result.
> ...
>
> It would affect the result if it just happened to match any of the items
> below it. Improbable, but the nastiest bugs arise from improbable
> situations.

While I usually try to eliminate any risk, the risk here is so remote
that I don't see it as an issue.

Also, I carried out an informal test to compare the re-calculation speed
between your solution and mine. Here's what I did...

1) used separate workbooks for each solution

2) expanded the range to A2:A10000

3) copied the relevant formulas down to row 10,000

The results surprised me on two counts...

1) With regards to my solution alone, I was surprised with the time it
took to copy the formulas down to row 10,000 and the difference in
re-calculation speed (about 10 seconds).

2) With regards to the two solutions, I was surprised to see that there
didn't seem to be any difference in re-calculation speed. Both took
about 10 seconds.

Maybe the results would be different if the range was expanded to
A2:A65535 and formulas copied down as well.

Since there doesn't seem to be any real difference between the two
solutions, I think I'll stick with mine. :)
.

Relevant Pages

  • Re: Run-time error 4608
    ... >>> with a header, then I delete the header and close. ... >>> Sub UdskrivAlt() ... >>> Regards ... >>> Bodiller ...
    (microsoft.public.word.vba.general)
  • Re: Risk-Port 3270
    ... They are asking the probability of data being sniffed. ... That's where the risk might be. ... Recently I got a change request which is to be implemented on the ... Thanx & Regards ...
    (Security-Basics)
  • Re: Easier way to insert columns
    ... Dim i As Long, j As Long ... Regards, ... > Thanks Norman, ... >> with your intended header values. ...
    (microsoft.public.excel.programming)
  • Re: creating a fake From: email address
    ... Primoz ... > Press forward and remove the header which is now in the message. ... > Microsoft Office and Microsoft Office related News ... >> Best regards, ...
    (microsoft.public.outlook.general)
  • Re: changing Outlook Express source code from New Message
    ... You can save the draft message to the desktop and edit the header in Notepad ... > that is not displayed with the source code button. ... > I know there is no API available for Outlook Express. ... > Best regards, ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)