+ Reply to Thread
Results 1 to 3 of 3

Maximum and Minimum value lookup for 2 conditions

  1. #1
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Maximum and Minimum value lookup for 2 conditions

    Hello Friends

    Please find the attached 2010 Version Excel file <Maximum and Minimum value lookup for 2 conditions 250515 sss.xlsx>.

    I want to plot the maximum and minimum values for the given 2 conditions / inputs.

    thanks in advance

    thilag

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    6,516

    Re: Maximum and Minimum value lookup for 2 conditions

    For Maximum
    Please Login or Register  to view this content.
    For Minimum
    Please Login or Register  to view this content.
    ARRAY formula is used

    To enter ARRAY formula
    Paste the formula
    Press F2
    Press Ctrl+Shift+Enter keys together.

  3. #3
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Re: Maximum and Minimum value lookup for 2 conditions

    Dear friend

    Your formula working well thanks
    thilag

+ 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. the maximum and minimum limit
    By madhupangal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2015, 05:49 PM
  2. minimum value out of maximum values
    By shamym in forum Excel General
    Replies: 9
    Last Post: 01-21-2015, 05:42 AM
  3. [SOLVED] Need formula to lookup minimum/maximum value combined with multiple conditions
    By VincentNL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-29-2014, 09:27 AM
  4. [SOLVED] Sum minus up to a maximum and a minimum
    By Rompetelo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2013, 03:58 AM
  5. Maximum and Minimum
    By lurchybold in forum Excel General
    Replies: 6
    Last Post: 10-13-2010, 11:04 AM

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