+ Reply to Thread
Results 1 to 3 of 3

MIN value excluding blanks

  1. 06-19-2013, 04:07 PM #1
    coach.32
    coach.32 is offline
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    260

    MIN value excluding blanks

    The other day I posted a question about how do I find the MIN value from a column of data that excluded Blanks.
    I received an answer thankfully, but have now realised that I posted the wrong formula. Could someone tell me what I need to add to the
    following formula that will ignore the blank cells in the column? Thank-you in advance for any solutions given, I really appreciate the
    help I receive on a number of occasions from this forum and it's experts.

    {=MIN(IF(U10s!$H$2:$H$11296=Totals!$A6,U10s!$L$2:$L$11296,""))}
    Reply With QuoteRegister To Reply
  2. 06-19-2013, 04:31 PM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: MIN value excluding blanks

    You could give this one a try (untested)

    {=MIN(IF(and(U10s!$H$2:$H$11296<>"",U10s!$H$2:$H$11296=Totals!$A6),U10s!$L$2:$L$11296,""))}
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 06-19-2013, 04:52 PM #3
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: MIN value excluding blanks

    oeldere - the AND function does not have the desired effect within array formulas.

    You need to use multiplication instead:

    =MIN(IF((U10s!$H$2:$H$11296=Totals!$A6)*(U10s!$L$2:$L$11296<>""),U10s!$L$2:$L$11296,""))

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    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