+ Reply to Thread
Results 1 to 7 of 7

Finding Streaks with values of 70°F or higher

Hybrid View

  1. #1
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,095

    Re: Finding Streaks with values of 70°F or higher

    I obviously missunderstood word "streak"...

    But this is what I came with (year 2002) with two helper columns (you can hide them if you want)...
    of course, if Fotis solution works then go with it since this is giving you othar kind of result but since I've already made it, here it is.
    I've also removed several sheets due to file size.
    Attached Files Attached Files
    Never use Merged Cells in Excel

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Exclude zero when counting streaks (win/loss) and current streaks
    By poko10 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-11-2013, 06:06 AM
  2. [SOLVED] Finding closest higher value from the list
    By Lem Treursić in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2013, 05:55 AM
  3. Replies: 0
    Last Post: 09-27-2011, 10:31 AM
  4. Replies: 2
    Last Post: 05-31-2010, 03:23 PM
  5. Finding streaks in large sets of numbers
    By Jish in forum Excel General
    Replies: 4
    Last Post: 02-14-2010, 08:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1