+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Finding max values in between multiple set values

  1. 04-06-2012, 04:54 PM #1
    sparky87
    sparky87 is offline
    Registered User
    Join Date
    04-06-2012
    Location
    New England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Finding max values in between multiple set values

    I have an assignment that I am doing that is rather unique... I have a column with several zeros in it. The zeros represent an event, in other columns I have different values that I need to find the max value that fall inbetween all these zeros. The problem is the cells inbetween zeros vary. I want to say this involves and if statement that references a range between two set values. Ultimately giving me the max value for each set...... I hate life
    Reply With QuoteRegister To Reply
  2. 04-06-2012, 04:59 PM #2
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Finding max values in between multiple set values

    What are the rules? Do you need to find the max value between a specific zero-bound range? For each zero-bound range? Something else? Can you post some sample data or a sample workbook that demonstrates what you want?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1