+ Reply to Thread
Results 1 to 7 of 7

Minimum value lookup for 2 conditions excluding zeros

  1. 05-26-2015, 09:42 AM #1
    thilag
    thilag is offline
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Minimum value lookup for 2 conditions excluding zeros

    Hello Friends

    Please find the attached 2013 version file <Minimum value lookup for 2 conditions excluding zeros 260515 sss.xlsx>

    I want to look for the minimum value for the given 2 conditions by omitting zeros.

    thanks in advance

    thilag
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-26-2015, 09:55 AM #2
    nigelbloomy
    nigelbloomy is offline
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Minimum value lookup for 2 conditions excluding zeros

    This formula should work in H6 entered as an array.

    Please Login or Register  to view this content.
    Last edited by nigelbloomy; 05-26-2015 at 09:57 AM.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
    Reply With QuoteRegister To Reply
  3. 05-26-2015, 09:59 AM #3
    jayajaya_4
    jayajaya_4 is offline
    Forum Contributor jayajaya_4's Avatar
    Join Date
    05-09-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    259

    Re: Minimum value lookup for 2 conditions excluding zeros

    hey dear ur file is not getting viewed or download..pls re attach the file
    Reply With QuoteRegister To Reply
  4. 05-26-2015, 10:04 AM #4
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Minimum value lookup for 2 conditions excluding zeros

    Try this array formula:

    Please Login or Register  to view this content.
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
    Quang PT
    Reply With QuoteRegister To Reply
  5. 05-26-2015, 10:05 AM #5
    nigelbloomy
    nigelbloomy is offline
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Minimum value lookup for 2 conditions excluding zeros

    Actually this one will take care of the errors and make sure that blanks appear instead of zeros. It is also an array formula.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 05-26-2015, 10:06 AM #6
    Ali Kırksekiz
    Ali Kırksekiz is offline
    Forum Contributor
    Join Date
    01-28-2014
    Location
    Turkey
    MS-Off Ver
    Excel 2013
    Posts
    159

    Re: Minimum value lookup for 2 conditions excluding zeros 

    Please Login or Register  to view this content.
    This in an array formula and so must be confirmed with CTRL+SHIFT+ENTER and not just ENTER than drag down

    Change cell format (for H column)


    Cell Format : 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 05-27-2015, 09:34 AM #7
    thilag
    thilag is offline
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    Re: Minimum value lookup for 2 conditions excluding zeros

    Hello Friends

    All of your formulas working fine.

    thanks

    thilag
    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)

Similar Threads

  1. [SOLVED] Maximum and Minimum value lookup for 2 conditions
    By thilag in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-26-2015, 09:36 AM
  2. [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
  3. [SOLVED] Average for non-consecutive cells excluding zeros (even when they all contain zeros)
    By pao13 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2012, 04:32 PM
  4. [SOLVED] Need to find the minimum of three columns igore zeros unless all three are zeros
    By dcoates in forum Excel General
    Replies: 2
    Last Post: 06-12-2012, 02:24 PM
  5. Minimum value excluding zero?
    By Ritte in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 12-30-2009, 05:18 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1