+ Reply to Thread
Results 1 to 4 of 4

Maximum (highest) frequency of cells between two values in row

  1. #1
    Registered User
    Join Date
    07-07-2013
    Location
    Brazil
    MS-Off Ver
    Excel 2016
    Posts
    2

    Maximum (highest) frequency of cells between two values in row

    Hello,

    This is my first post and English is not my native, so I hope I can explain my issue.
    I have a spreadsheet that I want to calculate the maximum number of cells between two values. I did find a solution but it is not the smartest and requires a lot of formula typing.

    Here's the issue (see example spreadsheet attached as well)

    excel.PNG

    I want to count what is the highest interval between two FG values - In the figure you can see it is 7 cells, between first and second "FG". I used max(frequency(if...) and it works, the problem is that I was counting blanks ("") in the beginning, but now any other value can be inserted between "FGs" in the same row, but I still want to count the maximum interval between FG, ignoring any other value in between.
    In the spreadsheet attached you can see that I am using the same approach to account for different values, but I don't think it is clever to type multiple "IFs" to account for infinite values that can go between two "FG".

    Any help is appreciated. If you do not understand the question, I may try to rephrase it for better understanding.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Maximum (highest) frequency of cells between two values in row

    Using your posted workbook....

    Put these values in these cells
    Please Login or Register  to view this content.
    Put this ARRAY FORMULA, completed by pressing CTRL+SHIFT+ENTER (instead of just ENTER) in
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    07-07-2013
    Location
    Brazil
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: Maximum (highest) frequency of cells between two values in row

    Ron, thank you very much for your solution, it's working, it is more elegant and allow for expansion of future codes.
    I wish a very happy new year for all in this great forum.

    Best regards,

    Lito

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Maximum (highest) frequency of cells between two values in row

    Glad you got something you can use!

    If that resolves your issue, please take a moment to mark this thread as SOLVED (from the Thread Tools menu)

+ 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. [SOLVED] Finding the Value with Highest Frequency in a Range
    By soleimani1967 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2019, 05:25 PM
  2. Replies: 3
    Last Post: 06-09-2016, 12:51 PM
  3. Get maximum frequency in 9 weeks rolling period
    By baltblue in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2013, 11:37 AM
  4. Replies: 0
    Last Post: 09-11-2012, 05:16 AM
  5. Sort by Highest Frequency
    By britth in forum Excel General
    Replies: 2
    Last Post: 07-28-2012, 04:49 AM
  6. [SOLVED] Productsum: Highest Frequency Category, Specific Main Category, Frequency of Category
    By T86157 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2012, 12:43 PM
  7. [SOLVED] URGENT!!! RTD updates maximum frequency
    By marsou in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-08-2006, 05:00 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