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

1. ## 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. ## 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

3. ## 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. ## 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. ## 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. ## Re: Using MIN function in column with blanks

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

7. ## 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. ## 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?

9. ## 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. ## 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"?