Re: Highest total of any three consecutive numbers in a range.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hmmm...

I don't know if your reply is a vote of confidence or not! <g>

*Almost any* formula can fail if it's subjected to situations that are not
accounted for. But, only *you* know what the formula is to be used for and
under what conditions. For example, the formula *will* fail if there are
error values in your range or if there are TEXT entries in the range. I
don't know if it's possible that either of those conditions will occur so I
don't account for them in the formula. From my perspective, I can only make
suggestions based on the info you provide. If I make a generic suggestion
that accounts for errors and/or text entries and those are not possible
conditions then the formula I suggest is bloated with overkill and a waste
of resources.

I'm pretty sure the formula suggested does what you asked for! (but someone
will *force* it to fail under a not probable condition and let me know about
it (read: rub my face in it!))

--
Biff
Microsoft Excel MVP


<skablaw@xxxxxxxxx> wrote in message
news:0a1a0fb3-6c61-4084-9ceb-7ed147b7844a@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I've attempted Biff's solution multiple times with varying ranges and
integers and it always seems to give me the result I want so I think
I'm set. I always get nervous when I see responses of such varying
technique and complexity because it makes me think I'm missing
something haha!

Of all of the solutions I think this is the simplest and easiest for
me to duplicate for the specific result I'm looking for, although I
see some very powerful tools that could potentially be customized in
useful ways.

Has anyone tried Biff's method and found a specific scenario in which
it does not work?

-Stephen
Omaha, NE


.

Relevant Pages

  • Re: PLUG: PMAS
    ... it returns a "temporary failure" and logs the triplet. ... check_user: User malcsue is apparently a username but has no account: FAIL ...
    (comp.os.vms)
  • RE: Norton antivirus fails to scan files
    ... any groups that SYSTEM is a member of then it will fail as well. ... I've removed all other users from the ACL that have no business to ... NAV is started as system account as defined in control ... Also, are you referring to the local administrators> group, or the local administrator account? ...
    (Vuln-Dev)
  • Re: dts and access db
    ... The service account for SQL Server ... it's probably related to permissions or account ... The pkg doesn't fail manually, ...
    (microsoft.public.sqlserver.dts)
  • Re: PLUG: PMAS
    ... check_user: User xnwvcqvf is apparently a username but has no account: FAIL ... check_user: User antalyaivr is apparently a username but has no account: FAIL ...
    (comp.os.vms)
  • Re: Custom Services Failing on Restart when 70+ are running
    ... services run with different accounts, the same account or the local system ... But on reboot random custom services fail. ... It is normally 3-4 custom services that fail on reboot. ... When this happens on reboot Terminal services also fails to start. ...
    (microsoft.public.windows.server.general)