Using MIN function in column with blanks
Page 1 of 3 123 LastLast
Results 1 to 10 of 26

Thread: Using MIN function in column with blanks
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2012
    Location
    Muncie, IN
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Using MIN function in column with blanks

    I have a scoring sheet that lists scores in a column but never know how many names will be entered and want to find the minimum score in a column with several blanks above the formula

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,747
    Post Thanks / Like
    Mentioned
    66 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Using MIN function in column with blanks

    Which version of Excel are you using

    This formula is simplest but it is not available in earlier versions
    =MINIFS(C:C,C:C,"<>")

    Excel 2016 (Windows) 32 bit
    A
    B
    C
    D
    E
    F
    1
    100
    10
    =MINIFS(C:C,C:C,"<>")
    2
    25
    3
    4
    50
    5
    75
    6
    25
    7
    10
    8
    100
    9
    1100
    10
    27
    11
    100
    12
    13
    59
    14
    77
    Sheet: Sheet4
    Last edited by Yongle; Sep 4th, 2019 at 06:02 AM.

  3. #3
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,747
    Post Thanks / Like
    Mentioned
    66 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Using MIN function in column with blanks

    From your post, I assumed that the you had tried the obvious
    =MIN(C:C)

    That works for me and ignore blanks. Does it not work for you ?

  4. #4
    Board Regular
    Join Date
    Jul 2012
    Location
    Muncie, IN
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using MIN function in column with blanks

    Thank you for the reply. I have several rows with data (E through I) and in the row end in column (L) I have
    a +MIN(E5:I5) and that works fine then at the bottom of column (L) I have another =MIN(L5:L105) and that will not work as there are many blanks between row 5 and 105 so either it woll not work because of the blank rows or you cannot use the min statement on a column of generated numbers by the min statement at the end of the rows. thank you for any help you may wish to give.

  5. #5
    Board Regular
    Join Date
    Jul 2012
    Location
    Muncie, IN
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using MIN function in column with blanks

    Thank you for the reply. I have several rows with data (E through I) and in the row end in column (L) I have
    a +MIN(E5:I5) and that works fine then at the bottom of column (L) I have another =MIN(L5:L105) and that will not work as there are many blanks between row 5 and 105 so either it woll not work because of the blank rows or you cannot use the min statement on a column of generated numbers by the min statement at the end of the rows. thank you for any help you may wish to give

  6. #6
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,747
    Post Thanks / Like
    Mentioned
    66 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Using MIN function in column with blanks

    What is a in
    a +MIN(E5:I5)

  7. #7
    Board Regular
    Join Date
    Jul 2012
    Location
    Muncie, IN
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using MIN function in column with blanks

    Thank you for the reply. I have several rows with data (E through I) and in the row end in column (L) I have

    =MIN(E5:I5) and that works fine then at the bottom of column (L) I have another =MIN(L5:L105) and that will not work as there are many blanks between row 5 and 105 so either it will not work because of the blank rows or you cannot use the min statement on a column of generated numbers by the min statement at the end of the rows. thank you for any help you may wish to give

    ---End Quote---

  8. #8
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    27,055
    Post Thanks / Like
    Mentioned
    461 Post(s)
    Tagged
    46 Thread(s)

    Default Re: Using MIN function in column with blanks

    In what way is you formula not working?
    Also are the blanks actually blank or do they show 0 as there is nothing in that row?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  9. #9
    Board Regular
    Join Date
    Jul 2012
    Location
    Muncie, IN
    Posts
    83
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Using MIN function in column with blanks

    yes the cells are blank and after using =min(l5:l105) in cell l106 I just get a blank cell but the formula is still there

  10. #10
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    27,055
    Post Thanks / Like
    Mentioned
    461 Post(s)
    Tagged
    46 Thread(s)

    Default Re: Using MIN function in column with blanks

    Are you sure that your blanks are actually blank? Rather than contain a 0 that is hidden by formatting, or because you have unchecked "Show a zero in cells that have zero value"?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •