+ Reply to Thread
Results 1 to 5 of 5

Streaks in a row

  1. #1
    Registered User
    Join Date
    03-04-2019
    Location
    Hattiesburg, MS
    MS-Off Ver
    2016
    Posts
    7

    Streaks in a row

    What if I had:

    table.PNG

    and I wanted to check three things. Are there numbers of any value greater than 0, in five or more consecutive cells? If so, how many consecutive cells and what is the sum of those numbers? The results would be put into three separate columns.
    Last edited by rhuen; 03-05-2019 at 07:00 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Frequency in a Row of Numbers

    Hi rhuen,

    What do I win by doing this problem??? See the answer in the attached.. I made helper columns for the first part and then used them for question 2 and 3.

    Sum of more than 5 GT 0 in a row.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    03-04-2019
    Location
    Hattiesburg, MS
    MS-Off Ver
    2016
    Posts
    7

    Re: Frequency in a Row of Numbers

    Quote Originally Posted by MarvinP View Post
    Hi rhuen,

    What do I win by doing this problem??? See the answer in the attached.. I made helper columns for the first part and then used them for question 2 and 3.

    Attachment 614035
    Reputation, I guess?? Thanks so much. I'm new to Excel and quickly learning so many things thanks to people like you. Hopefully, eventually, I won't have to keep bugging people on forums.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Frequency in a Row of Numbers

    Hi,

    Thanks for the rep but I keep learning new stuff all the time. I learned how to do "Fill Down" from someone a few days ago. It doesn't come all at once. You need to keep wondering, trying and learning.

    BTW = Fill Down was a
    1. Select the range
    2. Go To Special and select Blanks
    3. Put a "=A1" (A1 is the cell above first blank cell) and do a Ctrl+Enter!! Blew my mind!!!

  5. #5
    Registered User
    Join Date
    03-04-2019
    Location
    Hattiesburg, MS
    MS-Off Ver
    2016
    Posts
    7

    Re: Frequency in a Row of Numbers

    Hello again,

    Any ideas as to how I could go about determining the MAX number in the longest streak if there are multiple streaks? I'm unsure of how to use the MATCH function. We would use that, correct? I'll attach a new file with multiple streaks.

    I should probably rename the original post, this isn't really frequency...

    I figured out that I could simply change the SUM function to MAX:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by rhuen; 03-06-2019 at 11:25 AM.

+ 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. Replies: 3
    Last Post: 01-21-2016, 02:23 PM
  2. frequency of a set of numbers
    By norms in forum Excel General
    Replies: 4
    Last Post: 11-14-2014, 04:01 AM
  3. Replies: 3
    Last Post: 10-30-2014, 03:57 PM
  4. Frequency of Negative Numbers
    By carhw in forum Excel General
    Replies: 2
    Last Post: 04-04-2012, 02:49 PM
  5. Frequency of associated numbers in a table
    By telcotech in forum Excel General
    Replies: 6
    Last Post: 03-08-2009, 03:56 PM
  6. Frequency of Numbers
    By shane24 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-09-2005, 04:18 PM
  7. Random Numbers with frequency of 1
    By jwoodrup in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2005, 12:29 AM

Tags for this Thread

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