+ Reply to Thread
Results 1 to 2 of 2

Min function problems

  1. #1
    Registered User
    Join Date
    04-11-2007
    Posts
    82

    Min function problems

    Hi !! Hope you geniuses can help me.. this is driving me crazy.

    I need to find the smallest number in column "d", but only if the corresponding row, column "a" = yes.


    for example:
    A l B C D
    1 yes x o 3
    2 no x o 1
    3 yes x o 2
    4 yes x o 4
    so, in this instance i need a formula to bring back the number "2", since its the smallest number that appears on the same line as "yes"..

    I've tried other formulas, but they keep bringing back "1".



    Thank you sooo much!!!
    Last edited by mitelkm; 08-20-2008 at 02:27 PM.

  2. #2
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264
    Hi

    You need an array formula for this:

    =MIN(IF(A1:A4="yes",D1:D4))

    entered with Ctrl+Shift+Enter - if entered correctly, Excel will surround the formula with curly braces {} (do not enter these manually yourself).

    Richard

+ 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. Excel 2007 error when adding custom help file to user defined function
    By sabotuer99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2009, 01:10 AM
  2. Problems with ABS() function
    By Jon100 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-18-2008, 08:11 AM
  3. Problems with multiple statements IF function (Excel 2003)
    By Manupi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-18-2008, 03:49 PM
  4. Analysis Toolpak Function XIRR and VBA - XL 2007
    By rvExcelNewTip in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2007, 04:35 AM
  5. Function problems, please help
    By mamagoochie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2006, 10:20 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